BigQuery export and import limits
Export a BigQuery result to CSV, JSON, XLSX or Markdown without running the query again. Tablyne has no import into BigQuery.
Tablyne exports results from BigQuery. It does not import into it.
Exporting a result
Use the export action on a console result. It opens the same dialog as the other engines. The export writes the result that Tablyne already stored on disk, so it does not run the query again, and nothing is billed a second time.
The formats are CSV, JSON, XLSX and Markdown. The app refuses to export BigQuery results as SQL, with the message “Exporting as SQL is not available for BigQuery”. Its SQL writer targets other dialects, and Tablyne prefers a refusal to an INSERT that is almost GoogleSQL.
Values keep the exact text the server sent. INT64 values too large for a double, NUMERIC and BIGNUMERIC come out as text, so no digits are lost. STRUCT and ARRAY values come out as JSON in the order of the schema.
CSV exports neutralize text that a spreadsheet would run as a formula. This is on by default, and you can turn it off per export.
What the export holds
The export holds what the console kept. If a result was cut at the row limit, the byte limit or the disk quota, the console said so, and the export is cut at the same place.
Import
BigQuery has no import in Tablyne, because the connection is read-only. To move data into BigQuery, use a tool built for loading.