Request for Documentation: Internal Parameters for Endpoint-Level Data Type Configuration in Qlik Replicate

Ayman1 — Thu, 16 Jan 2025 15:29:38 GMT

I’m working on modifying an endpoint in Qlik Replicate using internal parameters within the Advanced Settings at the endpoint target level.

The primary goal is to address an issue where metadata tables being generated in Snowflake are appearing in an incompatible format. This issue cannot be resolved at the global parameters level because global parameters only apply to the task-level tables. Instead, I want to configure the endpoint so that any table created, altered, or dropped adheres to a specific format.

Here’s what I’ve achieved so far:

I successfully used the following internal parameters to manage table creation, alteration, and drop operations:
- $info.query_syntax.create_primary_key
- $info.query_syntax.create_table
- $info.query_syntax.drop_table

However, I’m facing challenges in configuring data type conversions at the endpoint level, particularly:

Adjusting the precision of VARCHAR fields (e.g., setting them to VARCHAR(16777216) or ensuring max length for Iceberg compatibility).
Modifying datetime and timestamp data types (e.g., setting all timestamps to TIMESTAMP(6)).

I’ve been unable to find documentation that lists all available internal parameters and examples for data type adjustments. I’ve seen partial references in the community but no comprehensive documentation.

Could you please provide:

A list of internal parameters available for endpoint-level configurations.
Examples or documentation specifically showing how to alter data types (e.g., VARCHAR precision or datetime adjustments) at the endpoint level.

This would greatly help in developing tasks that align with Iceberg table requirements in Snowflake.

Thank you for your assistance!

Re: Request for Documentation: Internal Parameters for Endpoint-Level Data Type Configuration in Qlik Replicate

Dana_Baldwin — Thu, 16 Jan 2025 18:31:11 GMT

Hi @Ayman1

I apologize but we don't have this information documented. Others may be able to help address your specific question, but may I suggest you request this documentation directly from our Product Management team here: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Thanks,

Dana

topic Re: Request for Documentation: Internal Parameters for Endpoint-Level Data Type Configuration in Qlik Replicate in Qlik Replicate

Request for Documentation: Internal Parameters for Endpoint-Level Data Type Configuration in Qlik Replicate

Re: Request for Documentation: Internal Parameters for Endpoint-Level Data Type Configuration in Qlik Replicate