sfquickstarts icon indicating copy to clipboard operation
sfquickstarts copied to clipboard

Non-standard SQL in site/sfguides/src/accelerate_your_graphql_development_on_snowflake_with_hasura

Open louspringer opened this issue 2 years ago • 0 comments

Describe the bug Quick start "Accelerate Your GraphQL Development on Snowflake with Hasura" refers to a SQL file in a foreign repository https://raw.githubusercontent.com/hasura/snowflake-quickstart/main/sql/sample_music_database.sql. This SQL creates tables with quoted lowercase identifiers. This is nonstandard and confounds typical SQL tooling.

URL of where you see the bug https://github.com/Snowflake-Labs/sfquickstarts/tree/master/site/sfguides/src/accelerate_your_graphql_development_on_snowflake_with_hasura

To Reproduce Steps to reproduce the behavior:

  1. Go to 'https://github.com/Snowflake-Labs/sfquickstarts/tree/master/site/sfguides/src/accelerate_your_graphql_development_on_snowflake_with_hasura'
  2. Click on 'Copy the SQL Script and paste...'
  3. Use the script to create the music database
  4. Observe non-standard lowercase schema objects

Expected behavior

  • SQL and other code artifacts for Snowflake schemas should be hosted by the Snowflake-Labs organization.
  • SQL should conform to reasonable standards and practices.

Screenshots N/A

Desktop (please complete the following information): N/A

Smartphone (please complete the following information): N/A

louspringer avatar Mar 09 '24 18:03 louspringer