Untitled
Anonymous
plain_text
03/08/2023 1:03 PM
644 B
15
Indexable
#Python
%sql
df_test2= df_test2.filter(col("country_region")== "US")
%sql
target_folder_path= 'abfss://[email protected]/refined/test_2_sql/'
df_test2.write.format("parquet").save(target_folder_path)
#SQL
%sql
CREATE TABLE IF NOT EXISTS test.dfc_test_data_usa
USING PARQUET
LOCATION 'abfss://[email protected]/refined/test_2_sql/'
AS
SELECT * FROM test_dfc_test
WHERE country_region="US"Editor is loading...