Skip to content

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.

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…).
Facebook 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.
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.

In Looker Studio, Tableau, Power BI, Qlik, Excel and Google Sheets, Datama reads the fields of the visual instead. See Environments.