Felipe Hoffa

Felipe Hoffa has asked 48 questions and find answers to 258 problems.

Stats

About

Data Cloud Advocate, Snowflake

https://medium.com/@hoffa/

Felipe Hoffa questions

appengine: cached reference property?
ARRAY_REMOVE() in Snowflake?
How can I split a string into character in Snowflake?
How to generate data to test Snowflake abilities to handle tables with thousands of columns?
How can I get currency exchange rates in Snowflake? (Historic and updated daily) [closed]
SQL Snowflake Scripting - How can I return a table created in memory while looping?
How to read a .sav SPSS file in in R?
How to find the most common bi-grams with BigQuery?
I want "live materialized views", with the latest info for any row
How to auth into BigQuery on Google Compute Engine?

Felipe Hoffa answers

Difference between LATERAL FLATTEN(...) and TABLE(FLATTEN(...)) in Snowflake
Bigquery conditional split aggregations fail
Can not select _PARTIONTIME in SELECT but can select it in INSERT
Bigquery SQL - Is it better to unnest in SELECT or JOIN?
sum of results inconsistent when grouping by
How can I make this query run efficiently?
Snowflake/javascript datetime format changes during iteration
google big query limit clause returning too many rows
Snowpark UDF with Row input type
Convert Empty string ("") to Double data type while importing data from JSON file using command line BQ command