Connect a source
This page does not apply to the environment you selected. It covers: Web app.
A data layer starts with one or more source blocks: open Add data source and choose a source type. Each source loads a table; you can then clean and combine several of them before the analysis.
The Add data source dialog groups the sources in two families.
Personal dataset
Section titled “Personal dataset”| Source | Loads |
|---|---|
| Google Sheets | A sheet of a public or private spreadsheet. |
| Google Analytics 4 | A report on a Google Analytics 4 property. |
| CSV File | An uploaded .csv file. |
| Excel | A sheet of an uploaded .xlsx file. |
| BigQuery | The result of a SQL query. |
| Snowflake | The result of a SQL query. |
| SQL | The result of a query on a SQL database (PostgreSQL, MySQL, MariaDB…). |
| A report on an ad account. | |
| Metabase | The result of a SQL query on a Metabase database. |
| Piano Analytics | A report of the Piano data query explorer. |
| Amazon Redshift | The result of a SQL query. |
| Emails | The reports an ad provider sends by email. |
Public dataset
Section titled “Public dataset”| Source | Loads |
|---|---|
| Calendar | A calendar of events: .ics, Google Calendar, Outlook, or one suggested by Datama. |
| AI Generator | A synthetic dataset and its market equation, from a prompt. |
Calendars can also be created from your account. See Calendars.
With BigQuery, Snowflake and Redshift you can also connect to a table without writing a query: see Table connect.
For performance, source blocks are cached for one hour. If your data changed within the hour, refresh the data from the header to load it again. Uploaded files are cached until you upload them again.
Other environments
Section titled “Other environments”In Looker Studio, Tableau, Power BI, Qlik, Excel and Google Sheets, Datama reads the fields of the visual instead. See Environments.