Solved: Creating and updating a temporary table in LookML - Page 2

JVFrancis · 08-26-2024 04:55 PM

I am trying to create/update table/view inside a SQL based derived_table in LookML. Is that possible? I keep getting an error which prevents the creation of the PDT in Looker but the query statements run fine in BigQuery and the table/view gets created in the temp database. Can someone please help?

marcwo

Are you trying to create this using the regular derived table syntax

view: customer_order_summary {
  derived_table: {
    sql:
      YOUR SQL CODE
  }
}

Or have you tried using the sql_create LookML syntax?

View solution in original post