java.lang.Object
- com.amazonaws.athena.connectors.snowflake.SnowflakeConstants

public final class SnowflakeConstants
extends Object

Field Summary

Fields
Modifier and Type	Field	Description
`static String`	`AUTH_CODE`	OAuth 2.0 Authentication Constants These constants are used for configuring OAuth-based authentication with Snowflake.
`static String`	`AUTHENTICATOR`	Configuration key for specifying the authentication method
`static String`	`BLOCK_PARTITION_COLUMN_NAME`	Partition key
`static String`	`CLIENT_ID`
`static String`	`CLIENT_SECRET`
`static String`	`COPY_INTO_QUERY_TEMPLATE`
`static String`	`COUNT_RECORDS_QUERY`	Snowflake metadata query
`static String`	`DESCRIBE_STORAGE_INTEGRATION_TEMPLATE`
`static String`	`DOUBLE_QUOTE_CHAR`
`static Map<String,String>`	`JDBC_PROPERTIES`
`static long`	`LARGE_TABLE_THRESHOLD`	Tables exceeding this row count threshold will skip the expensive primary key uniqueness check and fall back to single partition.
`static String`	`LIST_PAGINATED_TABLES_QUERY`
`static int`	`MAX_PARTITION_COUNT`	This constant limits the number of partitions.
`static String`	`PASSWORD`
`static String`	`PASSWORD_UPPERCASE`
`static String`	`PEM_PRIVATE_KEY`
`static String`	`PEM_PRIVATE_KEY_PASSPHRASE`
`static String`	`PRIVATE_KEY`
`static String`	`REDIRECT_URI`
`static String`	`S3_ENHANCED_PARTITION_COLUMN_NAME`
`static String`	`SF_USER`	Key-Pair Authentication Constants These constants are used for configuring public/private key pair authentication with Snowflake.
`static String`	`SHOW_PRIMARY_KEYS_QUERY`
`static String`	`SINGLE_QUOTE_CHAR`
`static int`	`SINGLE_SPLIT_LIMIT_COUNT`	This constant limits the number of records to be returned in a single split.
`static int`	`SNOWFLAKE_DEFAULT_PORT`
`static String`	`SNOWFLAKE_DRIVER_CLASS`
`static String`	`SNOWFLAKE_ENABLE_S3_EXPORT`	S3 export related constant.
`static String`	`SNOWFLAKE_NAME`	JDBC related config
`static String`	`SNOWFLAKE_SPLIT_EXPORT_BUCKET`
`static String`	`SNOWFLAKE_SPLIT_OBJECT_KEY`
`static String`	`SNOWFLAKE_SPLIT_QUERY_ID`
`static String`	`SSL_CERT_FILE_LOCATION`	A ssl file location constant to store the SSL certificate The file location is fixed at /tmp directory to retrieve ssl certificate location
`static String`	`SSL_CERT_FILE_LOCATION_VALUE`
`static String`	`STORAGE_INTEGRATION_BUCKET_KEY`
`static String`	`STORAGE_INTEGRATION_CONFIG_KEY`
`static String`	`STORAGE_INTEGRATION_PROPERTY_KEY`
`static String`	`STORAGE_INTEGRATION_PROPERTY_VALUE_KEY`
`static String`	`STORAGE_INTEGRATION_STORAGE_PROVIDER_KEY`
`static String`	`TOKEN_URL`
`static int`	`UNIQUENESS_CHECK_TIMEOUT_SECONDS`	Statement-level timeout (in seconds) for the primary key uniqueness check query.
`static String`	`USER`
`static String`	`USERNAME`	Password Authentication Constants These constants are used for traditional username/password authentication with Snowflake.
`static String`	`USERNAME_UPPERCASE`
`static String`	`VIEW_CHECK_QUERY`	Query to check view

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type Method Description

static boolean isS3ExportEnabled(Map<String,String> configOptions)
- Methods inherited from class java.lang.Object
  clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - SNOWFLAKE_NAME
```
public static final String SNOWFLAKE_NAME
```
    JDBC related config
    
    See Also:
    
    Constant Field Values
  - SNOWFLAKE_DRIVER_CLASS
```
public static final String SNOWFLAKE_DRIVER_CLASS
```
    See Also:
    
    Constant Field Values
  - SNOWFLAKE_DEFAULT_PORT
```
public static final int SNOWFLAKE_DEFAULT_PORT
```
    See Also:
    
    Constant Field Values
  - JDBC_PROPERTIES
```
public static final Map<String,String> JDBC_PROPERTIES
```
  - MAX_PARTITION_COUNT
```
public static final int MAX_PARTITION_COUNT
```
    This constant limits the number of partitions. The default set to 50. A large number may cause a timeout issue. We arrived at this number after performance testing with datasets of different size
    
    See Also:
    
    Constant Field Values
  - SINGLE_SPLIT_LIMIT_COUNT
```
public static final int SINGLE_SPLIT_LIMIT_COUNT
```
    This constant limits the number of records to be returned in a single split.
    
    See Also:
    
    Constant Field Values
  - LARGE_TABLE_THRESHOLD
```
public static final long LARGE_TABLE_THRESHOLD
```
    Tables exceeding this row count threshold will skip the expensive primary key uniqueness check and fall back to single partition.
    
    See Also:
    
    Constant Field Values
  - UNIQUENESS_CHECK_TIMEOUT_SECONDS
```
public static final int UNIQUENESS_CHECK_TIMEOUT_SECONDS
```
    Statement-level timeout (in seconds) for the primary key uniqueness check query. If the query exceeds this timeout, it will be cancelled and the connector will fall back to single partition rather than waiting for the Lambda timeout (900s).
    
    See Also:
    
    Constant Field Values
  - DOUBLE_QUOTE_CHAR
```
public static final String DOUBLE_QUOTE_CHAR
```
    See Also:
    
    Constant Field Values
  - SINGLE_QUOTE_CHAR
```
public static final String SINGLE_QUOTE_CHAR
```
    See Also:
    
    Constant Field Values
  - BLOCK_PARTITION_COLUMN_NAME
```
public static final String BLOCK_PARTITION_COLUMN_NAME
```
    Partition key
    
    See Also:
    
    Constant Field Values
  - S3_ENHANCED_PARTITION_COLUMN_NAME
```
public static final String S3_ENHANCED_PARTITION_COLUMN_NAME
```
    See Also:
    
    Constant Field Values
  - SSL_CERT_FILE_LOCATION
```
public static final String SSL_CERT_FILE_LOCATION
```
    A ssl file location constant to store the SSL certificate The file location is fixed at /tmp directory to retrieve ssl certificate location
    
    See Also:
    
    Constant Field Values
  - SSL_CERT_FILE_LOCATION_VALUE
```
public static final String SSL_CERT_FILE_LOCATION_VALUE
```
    See Also:
    
    Constant Field Values
  - SNOWFLAKE_SPLIT_QUERY_ID
```
public static final String SNOWFLAKE_SPLIT_QUERY_ID
```
    See Also:
    
    Constant Field Values
  - SNOWFLAKE_SPLIT_EXPORT_BUCKET
```
public static final String SNOWFLAKE_SPLIT_EXPORT_BUCKET
```
    See Also:
    
    Constant Field Values
  - SNOWFLAKE_SPLIT_OBJECT_KEY
```
public static final String SNOWFLAKE_SPLIT_OBJECT_KEY
```
    See Also:
    
    Constant Field Values
  - AUTHENTICATOR
```
public static final String AUTHENTICATOR
```
    Configuration key for specifying the authentication method
    
    See Also:
    
    Constant Field Values
  - AUTH_CODE
```
public static final String AUTH_CODE
```
    OAuth 2.0 Authentication Constants These constants are used for configuring OAuth-based authentication with Snowflake.
    
    See Also:
    
    Constant Field Values
  - CLIENT_ID
```
public static final String CLIENT_ID
```
    See Also:
    
    Constant Field Values
  - TOKEN_URL
```
public static final String TOKEN_URL
```
    See Also:
    
    Constant Field Values
  - REDIRECT_URI
```
public static final String REDIRECT_URI
```
    See Also:
    
    Constant Field Values
  - CLIENT_SECRET
```
public static final String CLIENT_SECRET
```
    See Also:
    
    Constant Field Values
  - SF_USER
```
public static final String SF_USER
```
    Key-Pair Authentication Constants These constants are used for configuring public/private key pair authentication with Snowflake.
    
    See Also:
    
    Constant Field Values
  - PEM_PRIVATE_KEY
```
public static final String PEM_PRIVATE_KEY
```
    See Also:
    
    Constant Field Values
  - PEM_PRIVATE_KEY_PASSPHRASE
```
public static final String PEM_PRIVATE_KEY_PASSPHRASE
```
    See Also:
    
    Constant Field Values
  - PRIVATE_KEY
```
public static final String PRIVATE_KEY
```
    See Also:
    
    Constant Field Values
  - USERNAME
```
public static final String USERNAME
```
    Password Authentication Constants These constants are used for traditional username/password authentication with Snowflake.
    
    See Also:
    
    Constant Field Values
  - PASSWORD
```
public static final String PASSWORD
```
    See Also:
    
    Constant Field Values
  - USERNAME_UPPERCASE
```
public static final String USERNAME_UPPERCASE
```
  - PASSWORD_UPPERCASE
```
public static final String PASSWORD_UPPERCASE
```
  - USER
```
public static final String USER
```
    See Also:
    
    Constant Field Values
  - SNOWFLAKE_ENABLE_S3_EXPORT
```
public static final String SNOWFLAKE_ENABLE_S3_EXPORT
```
    S3 export related constant.
    
    See Also:
    
    Constant Field Values
  - STORAGE_INTEGRATION_CONFIG_KEY
```
public static final String STORAGE_INTEGRATION_CONFIG_KEY
```
    See Also:
    
    Constant Field Values
  - DESCRIBE_STORAGE_INTEGRATION_TEMPLATE
```
public static final String DESCRIBE_STORAGE_INTEGRATION_TEMPLATE
```
    See Also:
    
    Constant Field Values
  - STORAGE_INTEGRATION_PROPERTY_KEY
```
public static final String STORAGE_INTEGRATION_PROPERTY_KEY
```
    See Also:
    
    Constant Field Values
  - STORAGE_INTEGRATION_PROPERTY_VALUE_KEY
```
public static final String STORAGE_INTEGRATION_PROPERTY_VALUE_KEY
```
    See Also:
    
    Constant Field Values
  - STORAGE_INTEGRATION_BUCKET_KEY
```
public static final String STORAGE_INTEGRATION_BUCKET_KEY
```
    See Also:
    
    Constant Field Values
  - STORAGE_INTEGRATION_STORAGE_PROVIDER_KEY
```
public static final String STORAGE_INTEGRATION_STORAGE_PROVIDER_KEY
```
    See Also:
    
    Constant Field Values
  - COUNT_RECORDS_QUERY
```
public static final String COUNT_RECORDS_QUERY
```
    Snowflake metadata query
    
    See Also:
    
    Constant Field Values
  - SHOW_PRIMARY_KEYS_QUERY
```
public static final String SHOW_PRIMARY_KEYS_QUERY
```
    See Also:
    
    Constant Field Values
  - COPY_INTO_QUERY_TEMPLATE
```
public static final String COPY_INTO_QUERY_TEMPLATE
```
    See Also:
    
    Constant Field Values
  - LIST_PAGINATED_TABLES_QUERY
```
public static final String LIST_PAGINATED_TABLES_QUERY
```
    See Also:
    
    Constant Field Values
  - VIEW_CHECK_QUERY
```
public static final String VIEW_CHECK_QUERY
```
    Query to check view
    
    See Also:
    
    Constant Field Values
- Method Detail
  - isS3ExportEnabled
```
public static boolean isS3ExportEnabled(Map<String,String> configOptions)
```

Class SnowflakeConstants

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

SNOWFLAKE_NAME

SNOWFLAKE_DRIVER_CLASS

SNOWFLAKE_DEFAULT_PORT

JDBC_PROPERTIES

MAX_PARTITION_COUNT

SINGLE_SPLIT_LIMIT_COUNT

LARGE_TABLE_THRESHOLD

UNIQUENESS_CHECK_TIMEOUT_SECONDS

DOUBLE_QUOTE_CHAR

SINGLE_QUOTE_CHAR

BLOCK_PARTITION_COLUMN_NAME

S3_ENHANCED_PARTITION_COLUMN_NAME

SSL_CERT_FILE_LOCATION

SSL_CERT_FILE_LOCATION_VALUE

SNOWFLAKE_SPLIT_QUERY_ID

SNOWFLAKE_SPLIT_EXPORT_BUCKET

SNOWFLAKE_SPLIT_OBJECT_KEY

AUTHENTICATOR

AUTH_CODE

CLIENT_ID

TOKEN_URL

REDIRECT_URI

CLIENT_SECRET

SF_USER

PEM_PRIVATE_KEY

PEM_PRIVATE_KEY_PASSPHRASE

PRIVATE_KEY

USERNAME

PASSWORD

USERNAME_UPPERCASE

PASSWORD_UPPERCASE

USER

SNOWFLAKE_ENABLE_S3_EXPORT

STORAGE_INTEGRATION_CONFIG_KEY

DESCRIBE_STORAGE_INTEGRATION_TEMPLATE

STORAGE_INTEGRATION_PROPERTY_KEY

STORAGE_INTEGRATION_PROPERTY_VALUE_KEY

STORAGE_INTEGRATION_BUCKET_KEY

STORAGE_INTEGRATION_STORAGE_PROVIDER_KEY

COUNT_RECORDS_QUERY

SHOW_PRIMARY_KEYS_QUERY

COPY_INTO_QUERY_TEMPLATE

LIST_PAGINATED_TABLES_QUERY

VIEW_CHECK_QUERY

Method Detail

isS3ExportEnabled