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 String`	`LIST_PAGINATED_TABLES_QUERY`
`static int`	`MAX_PARTITION_COUNT`	This constant limits the number of partitions.
`static String`	`PASSWORD`
`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 String`	`USER`
`static String`	`USERNAME`	Password Authentication Constants These constants are used for traditional username/password authentication with Snowflake.
`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
  - 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
  - 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

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

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