What table functions in the Snowflake Information Schema can be queried to retrieve information about directory tables? (Choose two.)
What table functions in the Snowflake Information Schema can be queried to retrieve information about directory tables? (Choose two.)
The two table functions in the Snowflake Information Schema that can be queried to retrieve information about directory tables are AUTO_REFRESH_REGISTRATION_HISTORY and STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY. AUTO_REFRESH_REGISTRATION_HISTORY retrieves the history of data files registered in the metadata of specified objects and the credits billed for these operations, while STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY provides information about the metadata history for a directory table, including any errors found when refreshing the metadata.
AUTO_REFRESH_REGISTRATION_HISTORY: Retrieve the history of data files registered in the metadata of specified objects and the credits billed for these operations. STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY: Retrieve information about the metadata history for a directory table, including any errors found when refreshing the metadata.
Information Schema The Snowflake Snowflake Information Schema includes table functions you can query to retrieve information about your directory tables. Table functions AUTO_REFRESH_REGISTRATION_HISTORY Retrieve the history of data files registered in the metadata of specified objects and the credits billed for these operations. STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY Retrieve information about the metadata history for a directory table, including any errors found when refreshing the metadata.
A and E r correct acc. to the info in https://docs.snowflake.com/en/user-guide/data-load-dirtables
A, E https://docs.snowflake.com/en/user-guide/data-load-dirtables
Answer - A,E https://docs.snowflake.com/en/user-guide/data-load-dirtables
https://docs.snowflake.com/en/sql-reference/functions/stage_directory_file_registration_history https://docs.snowflake.com/en/sql-reference/functions/external_table_files
Answer B,E