Skip to content
Snippets Groups Projects
Select Git revision
  • e3658e70702345a79902831821f97c9d89e09822
  • master default protected
  • demo1
3 results

first_view.sqlx

Blame
  • first_view.sqlx 683 B
    -- This is an example SQLX file to help you learn the basics of Dataform.
    -- Visit https://cloud.google.com/dataform/docs/sql-workflows for more information on how to configure your SQL workflow.
    
    -- You can delete this file, then commit and push your changes to your repository when you are ready.
    
    -- Config blocks allow you to configure, document, and test your data assets.
    config {
      type: "view", // Creates a view in BigQuery. Try changing to "table" instead.
      columns: {
        test: "A description for the test column", // Column descriptions are pushed to BigQuery.
      }
    }
    
    -- The rest of a SQLX file contains your SELECT statement used to create the table.
    
    SELECT 1 as test