Using its partner connector, Google Data Studio can quickly access TDengine and create interactive reports and dashboards using its web-based reporting features.The whole process does not require any code development. Share your reports and dashboards with individuals, teams, or the world. Collaborate in real time. And embbed your report on any web page.
Refer to GitHub for additional information on utilizing the Data Studio with TDengine.
Choose Data Source
The current connector supports two different types of data sources: TDengine Server and TDengine Cloud. Select "TDengine Cloud" and then click "NEXT".
To obtain the URL, please login TDengine Cloud and click "Visualize" and then select "Google Data Studio".
TDengine Cloud Token
To obtain the value of cloud token, please login TDengine Cloud and click "Visualize" and then select "Google Data Studio".
The database name that contains the table(no matter if it is a normal table, a super table or a child table) is the one you want to query for data and make reports on.
The name of the table that you wish to connect to in order to query its data and run a report.
Notice The maximum amount of records that may currently be retrieved is 1000000 rows.
Query range start date & end date
The page where we configure our connector has two text boxes.These two date filter conditions are used to limit the amount of data that will be retrieved, and the date should be entered in the format "YYYY-MM-DD HH:MM:SS." e.g.
The query result's start timestamp is defined by the
start date. To put it another way, records from before this
start date won't be received.
end time indicates the query result's end timestamp. Therefore, records that were written after this end date cannot be retrieved.
These conditions are utilized in the where clause in SQL statements, such as:
-- select * from table_name where ts >= start_date and ts <= end_date
select * from test.demo where ts >= '2022-05-10 18:24:15' and ts<='2022-05-12 18:24:15'
In fact, you can speed up the data loading in your report by using these filters.
Click "CONNECT" once configuration is complete, then you can connect to your "TDengine Cloud" with the given database and table.
Create Report or Dashboard
Unlock the power of your data with interactive dashboards and beautiful reports with the data stored in TDengine.
And refer to documentation for more details.