SnowPro Advanced: Data Engineer Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose BCF1

  • To create a DataFrame to hold the data from a file in a stage, use the read property to get a DataFrameReader object. In the DataFrameReader object, call the method corresponding to the format of the data in the file: # Create DataFrames from data in a stage. df_json = session.read.json("@my_stage2/data1.json") • To create a DataFrame to hold the results of a SQL query, call the sql method: # Create a DataFrame from a SQL query df_sql = session.sql("SELECT name from sample_product_data") • To create a DataFrame from data in a table, view, or stream, call the table method: # Create a DataFrame from the data in the "sample_product_data" table. df_table = session.table("sample_product_data")

• Chose BCF1

  https://docs.snowflake.com/en/developer-guide/snowpark/python/working-with-dataframes

• Chose BCF5

  df = session.sql("select 1/2") https://docs.snowflake.com/en/developer-guide/snowpark/reference/python/latest/api/snowflake.snowpark.DataFrame