Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Snowflake connector is failing to query/ingest tables with name starting &/OR ending with Quotation marks #3166

Closed
sidhreddy opened this issue Mar 5, 2022 · 0 comments · Fixed by #3174
Assignees
Labels
bug Something isn't working Ingestion

Comments

@sidhreddy
Copy link

Affected module
Does it impact the UI, backend or Ingestion Framework?
Ingestion

Describe the bug
A clear and concise description of what the bug is.
Snowflake connector is failing to correctly query/ingest tables with name starting & ending with Quotation marks.

To Reproduce

create test table

create or replace TABLE "test_tbl" (
	col int
);

--> Run ingestion

Expected behavior
A clear and concise description of what you expected to happen.
tables with name starting & ending with Quotation marks also need to be ingested onto OpenMetadata

Version:

  • OS: [e.g. iOS]: Mac os 11.6.2 (20G314)
  • Python version: Python 3.8.10
  • OpenMetadata version: [e.g. 0.8]: 0.8.15
  • OpenMetadata Ingestion package version: [e.g. openmetadata-ingestion[docker]==XYZ]

Additional context
Add any other context about the problem here.
Tables with this naming are failing with the below error.
Object TABLE does not exist or not authorized.

@sidhreddy sidhreddy changed the title Snowflake connector is failing to query/ingest tables with name starting & ending with Quotation marks Snowflake connector is failing to query/ingest tables with name starting &/OR ending with Quotation marks Mar 5, 2022
@ayush-shah ayush-shah self-assigned this Mar 5, 2022
@ayush-shah ayush-shah added bug Something isn't working Ingestion labels Mar 5, 2022
@ayush-shah ayush-shah added this to To do in Release 0.9.0 via automation Mar 5, 2022
@ayush-shah ayush-shah removed this from To do in Release 0.9.0 Mar 5, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working Ingestion
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants