[CIVIS-6409] Change civis_file_to_table to not use table ids to validate that a table exists

mjziolko commented 1 year ago

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
[x] 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
[x] The CircleCI builds have all passed

mjziolko commented 1 year ago

@jacksonlee-civis mind reviewing?

mattyb commented 7 months ago

Duplicates #467

civisanalytics / civis-python

[CIVIS-6409] Change civis_file_to_table to not use table ids to validate that a table exists #464