Looker Connector

is a free, online data visualization and business intelligence tool for connection to various data sources and creation of interactive dashboards and reports this connector enables clients to fetch data from an system for visualization in looker studio using the https //script google com/ platform prerequisites to use looker studio with the ocient system, you must have this software ocient system — use the latest version a google account with login credentials connect to ocient follow these steps to connect looker studio to your ocient system open looker studio and start a data source go to https //lookerstudio google com/ and sign in on the home page, select create > data source , or from an open report, resource > manage added data sources > add a data source select the ocient community connector in the connector gallery, select the community connectors section find and select the ocient db connector looker studio opens the ocient connector configuration page in the same tab complete the configuration page by entering text in the fields on the configuration page, select the allow to be modified checkbox next to each field to modify it this table contains descriptions for each field field description hostname hostname or ip address of the ocient sql node database database name in the ocient system user ocient username password password for the ocient username table ocient table name ( schema table ) row limit limit value to add to queries date range column name column name for the date or timestamp column in the where clause sort column column name for the order by clause sort order sort order with the option of ascending or descending unnest option specifies if array columns are unnested custom query a query that overrides the query generated by the connector the looker data source panel shows only the columns included in this query in this mode, looker studio infers column data types from the sample output, and not a describe table sql statement select connect select allow when looker studio prompts you with " allow parameter sharing? you can now use looker studio to create reports for your ocient system looker studio uses autocomplete in its filter tool, which can impact date or time filtering for records older than 28 days to fix this issue, navigate to the looker filter control and set show suggested values to off ocient data types in looker studio the connector represents ocient data types using the closest approximation supported by looker studio the inference of data types happens in looker studio in these ways in normal mode, the connector generates data types from the table schema produced by a describe table sql statement in custom query mode, looker studio infers data types from sample output this table shows how ocient data types correspond to looker studio data types ocient data type looker studio data type limitations boolean boolean none tinyint, smallint, int, bigint, double, float, decimal number none char varchar binary hash ipv4 ip uuid varbinary time text none point linestring polygon text looker studio community connectors can use latitude or longitude coordinates, but they do not support native wkt geospatial types date year month day none timestamp year month day second none char\[], varchar\[], binary\[], hash\[], ipv4\[], ip\[], uuid\[], varbinary\[], tuple\[] text looker studio does not support arrays or tuples as a native data type the connector represents container data types as textual strings for arrays, use the unnest option configuration field to flatten array columns for analytics for tuples, use the custom query field to extract the tuple elements setting the unnest option field does not work for flattening tuples related links docid\ tyktrvrfpdxdnt9gnwbrh docid\ lnhpyibsbwsksnslss1v9