Importing from databases | ATX AnalyticsTable Docs

Importing from databasesBigQuery, SQL Server, PostgreSQL, Oracle, DuckDB and SQLite. Reads a BigQuery table, or the result of a BigQuery query, into a sheet at a cell you choose. The rows are pulled through the connector, staged into the project database and then put through the SAME import planner a Parquet file goes through — so column types, keep/drop lists, a row filter, deduplication, the write mode (replace, append or upsert on a key), schema-drift handling and the minimum/maximum row guards all mean exactly what they mean for a file. A source row limit is pushed DOWN to BigQuery rather than applied afterwards, which is the difference between scanning a billion rows and not.

What this page covers

Get Data → BigQuery
Get Data → SQL Server
Get Data → PostgreSQL
Get Data → Oracle
Get Data → DuckDB
Get Data → SQLite

Settings and controls documented

Connection
SQL
Source row limit
New sheet name
Start cell
Cache table
Keep only these columns
Row filter
Column types
Write mode
Key columns
If the columns changed
Minimum rows

Full page

The full page — procedures and the explanation of every setting — is available to signed-in users.

ATX Institute on LinkedIn

This site needs JavaScript for the full experience. Every page above is reachable without it.