Snowflake agent properties (4369842)

Setting Account Details (mandatory)

• Organization – The organization that this account belongs to. The Foglight topology created for this account will be under this organization, so it is very important that any accounts belonging to this organization are all provided the exact same string in the agent properties. It is not required for this to match the organization name used by Snowflake.
• Account – Use the Snowflake Account Identifier in this field. This is The name this account will be given in Foglight. This is not used for connection purposes, so it is not required for this to match the account name used by Snowflake. This value is necessary to collect data. Missing this value may result in an error like this: "java.lang.IllegalArgumentException: The required identity property 'name' for 'Snowflake_Account' cannot be an empty string "

Setting Connection Details (mandatory)

• Account Identifier – This is generally in the format of organization-account and used in the URL for accessing an account like account_identifier.snowflakecomputing.com.
  • You can also find the organization and account ID in the Snowflake console Admin>Accounts page. Hovering over the account name will make visible a link icon with the URL for the account containing the account ID.
  • If hovering over the account name is empty, then try using the first two components of the URL such as when using AWS Privatelink. For example https://my-test.privatelink.snowflakecomputing.com might use the Account Identifier MY-TEST.PRIVATELINK. 
• Warehouse – Sets a default compute warehouse for the user provided to the agent to use when executing monitoring queries. If left blank, it will use the default warehouse assigned to the Snowflake user, if this exists. Read Selecting a Compute Warehouse earlier in this document for important information to consider when designating a warehouse.
• Username – The Snowflake user that will be running monitoring queries.
• Password – The password for the Snowflake user.
• Private Key Path – File path to an optional private key file for user authentication.
• Private Key Password – Password for the private key file.

Setting DB Overrides (optional)

• Database Name – The name of a database to override default collection properties for.
• Exclude DB-level Stats – If true, data will not be collected for schema, pipes, and tables belonging to this database.

Setting Top Tables Collection (optional)

• # of Top Tables – Maximum number of tables that will be included for each sample collection.
• Order By – Dimension by which to order the tables collected before the cutoff limit. For example, if Active Bytes is selected, then the x tables with the largest Active Bytes will be collected.

Setting Top SQL Collection (optional)

Collects individual top SQL statements run during the sample period according to the configured order by and limit properties.

• Enable Statement Tracking – If true, top statements will be collected based on the limit and order by values.
• # of Top Statements – Maximum number of statements that will be included in each sample collection.
• Statement Text Length – Cutoff limit for characters collected in a single SQL statement text string. If set to 0 or lower, the entire query text will be collected.
• Order by – Dimension by which to order the tables collected before the cutoff limit. For example, if Execution Time is selected, then the x statements with the longest Execution Time will be collected.

Setting Collection Intervals (optional)

The Collection Interval fields in the agent properties are used to set sample frequencies for collections. The values provided are the recommended default intervals. Certain collections are not included in this list due to technical requirements that they take place at specific intervals. Any collections that are removed from this list will be scheduled at their default interval, while providing an interval of 0 for a collection will disable it entirely.

• Collection Name – Name of the collection to override.
• Interval (sec) – Number of seconds between collection samples