SnowConvert AI - General Conversion Settings

File encoding settings

This setting in SnowConvert AI determines how the tool reads and interprets the text within your source files. Choosing the correct encoding is important to ensure that all characters, especially accented letters, symbols, or text from various languages, are processed correctly during conversion. By default SnowConvert AI uses UTF-8.

image

Manually Selecting an Encoding

You can choose to override this automatic process by selecting a specific encoding from the dropdown menu. If you select an encoding manually (even if you select UTF-8 explicitly), SnowConvert AI will use only that chosen encoding to read the files.

Available Encoding Options

The dropdown list allows you to force SnowConvert AI to use one of these specific encodings:

Code PageNameDisplay Name
1200utf-16Unicode
1201DunicodeFFFEUnicode (Big endian)
12000utf-32Unicode (UTF-32)
12001utf-32BEUnicode (UTF-32 Big endian)
20127us-asciiUS-ASCII
28591iso-8859-1Western European (ISO)
65000utf-7Unicode (UTF-7). Not available in .NET 5
65001utf-8Unicode (UTF-8). Default encoding

Understanding System Default (Preview)

When selecting the System Default (Preview) , SnowConvert AI uses a flexible approach:

  1. It first tries to automatically detect the specific character encoding of each input file.

  2. If auto-detection doesn't identify the encoding, SnowConvert AI proceeds using UTF-8, which handles a very wide range of characters and is common for modern files.

  3. As a fallback, if the UTF-8 interpretation fails because it finds characters that aren't valid in UTF-8, SnowConvert AI will then attempt to use your computer's default system encoding.

It's marked "Preview" because this behavior is experimental. System defaults can vary significantly between different computers and operating systems, potentially leading to inconsistent results or unsupported encodings.

Recommendation

If you encounter errors related to text interpretation or see garbled characters in your results, manually selecting the correct encoding is the best solution. If you know your files use a specific format (like Western European), select that. If you're unsure but suspect encoding issues, explicitly selecting UTF-8 is often a good starting point as it's the most common standard for modern files.

物化视图转换设置

在此页上,您将找到必要的选项,用于在转换期间自定义将物化视图(或 Teradata 中的联接索引)转换为动态表的参数。

image

image

To preserve the full functionality of Materialized Views, or Teradata's Join Indexes, SnowConvert AI generates Dynamic Tables instead of creating a one-to-one Materialized View or transforming a Join Index into a Materialized View. This approach is necessary because Snowflake lacks certain configuration options available in other systems' Materialized Views.

有关 Snowflake 物化视图限制的更多详细信息,请参阅 物化视图限制

Transformation

此处定义的设置将应用于转换过程中生成的动态表的每个实例。

动态表转换设置:

  • Target Lag:此设置指定动态表内容滞后于基表更新的最大允许时间。例如,将此值设置为 5 分钟可确保动态表中的数据滞后于基表更新不超过 5 分钟。

  • Warehouse: This setting specifies the name of the Warehouse that supplies the computing resources for refreshing the dynamic table. You must have the USAGE privilege on this warehouse to create the dynamic table. By default, SnowConvert AI will use a placeholder value.

有关更多信息,请参阅 Snowflake 动态表 文档

语言: 中文