Antoine Giraud
Antoine Giraud
This function was [added](https://unytics.io/bigfunctions/bigfunctions/sleep/) in décember 2023 : `bigfunctions.eu.sleep(10)` where sleep function get's seconds in param (not ms) i guess it covers this current need ?!
@shivam221098, example of use case : - propagating descriptions on columns from an other query ... where you can only do 5 DDL per 10 seconds !  example :...
from GCP's dataform issue [#366123439](https://issuetracker.google.com/issues/366123439) ## How this might work: - dataform's **GCP UI** : toggle option to choose for "prod" database for deferal in dev environements - dataforms's **CLI**...
PS: api refresh script functionnal on my side, just have to take te time to implement it the BigFunctions way ;) will craft it at the en of the month...
In a 2nd phase, we could add [DuckDB secret](https://duckdb.org/docs/extensions/httpfs/s3api.html) support :) ```sql CREATE SECRET secret1 ( TYPE S3, KEY_ID 'AKIAIOSFODNN7EXAMPLE', SECRET 'wJalrXUtnFEMI/xxxxxx/bPxRfiCYEXAMPLEKEY', REGION 'us-east-1' ); ``` before executing user's query...
Other option : configure some file types that we can query through DuckDB ```sql select bigfunction.eu.load_file( 'your_project.your_dataset.random_sales', -- table_name 'csv', -- src_type "https://xxxxx", -- url '{}' -- optional_args ); ```...
implemented in a new commit in PR https://github.com/unytics/bigfunctions/pull/166 :)
It's a go live 🥳 cf. [load_file](https://unytics.io/bigfunctions/bigfunctions/load_file/) Thank's @unytics for the team work 🥳
example of use case : - propagating descriptions on columns from an other query ... where you can only do 5 DDL per 10 seconds !  example : ```sql...
ps: tried from an other windows 11 computer ... worked fined there ! 🧐 i'll try to reset duckdb on my 1st windows pc & install again h3 PS: congrat's...