Data warehouses, analytics and BI
Load business records into Snowflake, run saved read-only queries, sync HubSpot in bulk, read Google Analytics, Mixpanel and Amplitude, and refresh Power BI, Tableau, Looker, Metabase and dbt with your own keys.
Updated 14/10/2026
On this page
Most businesses keep their numbers in two places: the apps where work happens (a store, a payment provider, the books, a CRM) and a data platform where those numbers are combined and reported. These connectors join the two, in both directions.
Snowflake: load up to 500 rows at a time (insert, or update-or-insert by key so re-running a load never duplicates), and run a saved read-only query whose results go to Slack, Teams, a spreadsheet or another app.
HubSpot: create or update up to 100 records in one step by your own reference (for example an order number), read records in bulk, link records in bulk, create orders, record webinar and event attendance, and read invoices, payments, carts, subscriptions and leads.
Google Analytics 4, Mixpanel and Amplitude: read reports and daily figures into flows. Mixpanel and Amplitude can also receive events and profile updates from your other apps.
Power BI: add rows to a push dataset, refresh a semantic model and check that the refresh worked.
Tableau: refresh an extract, check the job, and save a view's data as a file.
Looker and Metabase: run saved Looks and questions and use their results in flows.
dbt Cloud: run a dbt job after a load, check the run, and read which models and tests passed.
You bring your own keys for each one. Nexra stores them encrypted and never uses keys of its own. Each connection page shows plain steps for creating the key, using the provider's own menu names. See Connections.
Start with test data
Few data tools have a separate sandbox, so test against test data first:
| App | Where your key is | How to test |
|---|---|---|
| Snowflake | Snowsight: a Nexra user with a key pair (or a programmatic access token) | A test database or a free trial account |
| HubSpot | Your HubSpot developer app's Client ID and secret | A free developer test account |
| Google Analytics 4 | A Google Cloud service account added to the property as Viewer | A test property |
| Mixpanel | Organization settings → Service Accounts | A second project in the same organisation |
| Amplitude | Settings → Projects → your project: API key and secret key | A test project |
| Power BI | A Microsoft Entra app registration added to a workspace | A test workspace |
| Tableau | My Account Settings → Personal Access Tokens | A test site or project |
| Looker | Admin → Users → Edit Keys | A user that sees only a test folder |
| Metabase | Admin → Settings → Authentication → API keys | A test collection |
| dbt Cloud | Account settings → Service tokens | A staging environment and job |
Queries stay read-only and bounded
Snowflake's Run a read-only query takes one SELECT query. Nexra refuses anything else, runs the query with a row limit on every page, and puts values in parameters rather than in the query text. You can give the connection a separate role that can only read. Loads into Snowflake are always built by Nexra from your column names and values, never from free text.
Reports in Google Analytics, Mixpanel, Amplitude, Power BI, Looker and Metabase run through each provider's own report API, with row limits. Metabase questions saved through Nexra use the query builder, never SQL.
Writes stay under your control
Every write, from a Snowflake load to a dbt job run, needs to be switched on for the connection and runs only in an approved flow. Loads that use warehouse credits, and dbt job runs, are marked as costing money. Nexra never deletes tables, datasets, content or users in these apps.
Reconcile with your books
Because loads can be read back, you can check that what reached the warehouse matches the source. For example: load each day's Stripe or Paystack payouts and Xero or QuickBooks deposits into Snowflake, run a saved query that lists the differences, and send it to the finance channel. HubSpot invoices and payments can be compared with the books the same way.