The civis_file_to_table relies on a table having an id to validate its existence. Big query tables do not have ids and are not stored in RDS. Instead, use the new /databases/:id/schemas/:schema_name/tables/:table_name endpoint to validate whether or not a table exists. This endpoint works for redshift, postgres, and big query tables.
[x] (For Civis employees only) Reference to a relevant ticket in the pull request title
[ ] Changelog entry added to CHANGELOG.md at the repo's root level
[x] Description of change in the pull request description
[x] If applicable, unit tests have been added and/or updated
The
civis_file_to_tablerelies on a table having an id to validate its existence. Big query tables do not have ids and are not stored in RDS. Instead, use the new/databases/:id/schemas/:schema_name/tables/:table_nameendpoint to validate whether or not a table exists. This endpoint works for redshift, postgres, and big query tables.CHANGELOG.mdat the repo's root level