Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Amazon SageMaker Lakehouse Connector

Amazon SageMaker Lakehouse Connector

Connection details

Connection details

The following table describes the basic connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Use Secret Vault
Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option.
For information about how to configure and use a secrets manager, see
"Secrets manager configuration" in the Administrator help
.
Runtime Environment
The name of the runtime environment where you want to run tasks.
Select a Secure Agent.
You cannot use Hosted Agent, elastic runtime environment, and serverless runtime environment.
For more information about how to configure and use the runtime environments, see
Runtime Environments
in the Administrator help.
Lakehouse Pattern
The pattern of Amazon SageMaker Lakehouse. Pattern is a combination of catalog type and storage type that you want to connect to.
Select one of the following options:
  • S3 Data Lake. To read from and write to Apache Iceberg tables that are managed by the AWS Glue Data catalog and stored in Amazon S3.
  • S3 Tables. To read from and write to Apache Iceberg tables that are managed by the S3 tables catalog and stored in Amazon S3.
S3 tables lakehouse pattern is available for preview.
Preview functionality is supported for evaluation purposes but is unwarranted and is not supported in production environments or any environment that you plan to push to production. Informatica intends to include the preview functionality in an upcoming release for production use, but might choose not to in accordance with changing market or technical circumstances. For more information, contact Informatica Global Customer Support.
Athena JDBC URL
The JDBC URL to connect to Amazon Athena.
For S3 Data Lake lakehouse pattern, enter the JDBC URL in the following format:
jdbc:athena://Region=<AWS_Region>;OutputLocation=<S3_Location>
For S3 Tables lakehouse pattern, enter the JDBC URL in the following format:
jdbc:athena://AwsRegion=us-east-1;Catalog=s3tablescatalog/your-bucket-name;Schema=your_namespace;
Where
s3tablescatalog/your-bucket-name
is your S3 table bucket catalog and
your_namespace
is the namespace where your table is stored.

0 COMMENTS

We’d like to hear from you!