Data sources
Connect the data sources your numbers live in
Seven connectors in the app cover any hosted Postgres or MySQL. GA4, Firebase, Search Console, Firestore and Stripe come in through their BigQuery exports. Every route has a setup guide, and every query runs read-only.
01A connector in the app
Connects directly
Sign in, or type the connection details once. Dataki queries your database, warehouse or sheet where it lives, the moment you ask, so every answer is current.
-
BigQuery A read-only service account in your project
-
PostgreSQL A read-only user, over TLS
-
MySQL A read-only user, over TLS
-
Amazon Redshift A read-only user, always over TLS
-
Supabase Sign in with Supabase, then add the password
-
Google Sheets Google sign-in, then pick a sheet
-
CSV and Excel Upload; each sheet becomes a table
Wherever your Postgres or MySQL lives
A hosted database is still Postgres or MySQL. Dataki connects over TLS whenever the
server offers it (every host below requires it) and always from one fixed address,
34.89.253.13. Allow that one IP and your firewall stays closed to everyone else.
02Native exports, read in place
Through BigQuery
Each of these already exports to BigQuery, most of them for free. Turn the export on, connect the dataset, and Dataki queries it like any other warehouse.
- Your product
- BigQuery
- Dataki
-
Google Analytics 4 GA4's free daily export: every event, unsampled. Guide · about 10 min
-
Firebase Firebase's export: Analytics, Crashlytics, Performance, Messaging. Guide · about 5 min
-
Google Search Console The bulk data export: every query and page, no row cap. Guide · about 10 min
-
Cloud Firestore Google's extension streams each change as it happens. Guide · about 15 min
-
Stripe BigQuery's own Stripe connector, free while in Preview. Guide · about 15 min
03Files and syncs
Through a file, or a sync
An export you upload
Upload a CSV or Excel export and query it with full SQL, each sheet as a table. Replace the file whenever you have a fresh export. MongoDB works this way today, or through a copy in BigQuery.
MongoDB guideAnything a sync can land
If a tool can land it in BigQuery or Postgres, Dataki reads it. BigQuery's own Data Transfer Service brings in Salesforce, HubSpot, Shopify, Google Ads and more (some in Preview), and Airbyte, Fivetran and dlt cover hundreds of others.
04Most requested
On the request list
The apps people ask about most. Their data reaches Dataki through the sync route above, ready to query alongside everything else.
- HubSpot
- Salesforce
- Shopify
- Zendesk
- Intercom
- RevenueCat
Need one of these, or a source only your company uses? We build custom connectors fast, typically in two to four weeks.
Your first month is free
Connect a source. Ask it something.
It takes about five minutes and a read-only connection. Every answer you keep becomes a dashboard with a link that stays live.