(aws-glue-alpha): No connection type for SNOWFLAKE

[marcus-linktree]

Describe the feature

Snowflake is a native connection type in Glue now, but Glue Alpha doesn't have an option for connection.type = SNOWFLAKE. This should be supported.

Use Case

Connecting from Glue to Snowflake easily.

Proposed Solution

Support the native Snowflake connector

Other Information

No response

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

AWS CDK Library version (aws-cdk-lib)

2.185.0

AWS CDK CLI version

2.128.0

Environment details (OS name and version, etc.)

N/A

[pahud]

Hi @marcus-linktree,

Thank you for this feature request! You're absolutely right that AWS Glue supports SNOWFLAKE as a native connection type, but our aws-glue-alpha module doesn't currently expose it as a static property.

I've confirmed that:

• ✅ AWS Glue service officially supports SNOWFLAKE connection type for use with AWS Glue for Spark workloads
• ✅ The ConnectionType class already has the infrastructure to support this
• ❌ We're missing the static readonly SNOWFLAKE property

Current workaround:

const connection = new Connection(this, 'SnowflakeConnection', {
 type: new ConnectionType('SNOWFLAKE'),
 // other properties...
});

Proposed solution:
Add a static readonly property following the existing pattern:

/**
 • Designates a connection to Snowflake.
*/
public static readonly SNOWFLAKE = new ConnectionType('SNOWFLAKE');

This is a straightforward addition that would align the CDK with AWS Glue's current capabilities. Since you mentioned you may be able to implement this feature request, I'd encourage you to submit a PR! The implementation would involve:

1. Adding the static property to the ConnectionType class
2. Adding unit tests
3. Updating documentation/README examples

Would you like to take this on? If you need any guidance on the contribution process, feel free to ask!

[marcus-linktree]

Thanks @pahud ! Sorry I missed your reply, looks like you've got it sorted. Looking forward to having this available, thank you

[Kasra-G]

For future reference, you can do the following in the meantime to unblock a missing ConnectionType

const connectionType = new ConnectionType("SNOWFLAKE");