Use the Google BigQuery Tools to query and write data to tables in Google BigQuery from Alteryx Designer.
Current version
-
Compatible with Alteryx version 2019.3 and later.
-
Updated the Google BigQuery Output tool to utilize bulk file write instead of streaming records to BigQuery. The tool now loads JSON files from the local machine into BigQuery. This resolves issues where records could be dropped during overwrite (DE28086).
-
End user authentication now works in proxy environments (DE25315).
-
Users can now see more than 50 projects in tool UI (DE28143).
- Required Python package updates.
Previous versions
-
Requires Alteryx version 2019.3 or higher.
-
Support for pre/post SQL queries is now available.
-
Tool now supports Append Existing and Overwrite table functionality.
-
Tool allows multi-level nested schema.
-
Support for repeated data types (i.e. BigQuery arrays) is now available.
-
Tool supports reading and writing None values.
-
Tool now shows more than 50 tables per schema - DE18562.
- Tool no longer fails when using Decimal\Numeric data types - DE20090.
- Fixed bug where connector connector would crash if a BigQuery dataset did not have any tables.
- Fixed issue preventing packages from being installed successfully.
- Initial release - Google BigQuery Input and Google BigQuery Output.
This tool uses a .yxi file format. A .yxi file is a package that includes an Alteryx Tool and all of its dependencies zipped into a single file. When this file is imported into Alteryx, the tool is added to the tool palette in the category specified by the tool.
When sharing a workflow that uses a .yxi tool, the tool is not included and must be installed by the recipient.
