# BigQuery Migration v2 API - Class Dialect (1.7.0)

1.7.0 (latest) 1.6.0 1.5.0 1.4.0 1.3.0 1.2.0 1.1.0 1.0.0

    public sealed class Dialect : IMessage<Dialect>, IEquatable<Dialect>, IDeepCloneable<Dialect>, IBufferMessage, IMessage

Reference documentation and code samples for the BigQuery Migration v2 API class Dialect.

The possible dialect options for translation.

## Inheritance

[object](https://learn.microsoft.com/dotnet/api/system.object) \> Dialect

## Implements

[IMessage](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IMessage-1.html)[Dialect](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.Dialect), [IEquatable](https://learn.microsoft.com/dotnet/api/system.iequatable-1)[Dialect](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.Dialect), [IDeepCloneable](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IDeepCloneable-1.html)[Dialect](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.Dialect), [IBufferMessage](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IBufferMessage.html), [IMessage](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IMessage.html)

## Inherited Members

[object.GetHashCode()](https://learn.microsoft.com/dotnet/api/system.object.gethashcode) [object.GetType()](https://learn.microsoft.com/dotnet/api/system.object.gettype) [object.ToString()](https://learn.microsoft.com/dotnet/api/system.object.tostring)

## Namespace

[Google.Cloud.BigQuery.Migration.V2](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2)

## Assembly

Google.Cloud.BigQuery.Migration.V2.dll

## Constructors

### Dialect()

    public Dialect()

### Dialect(Dialect)

    public Dialect(Dialect other)

| **Parameter** ||
|---|---|
| **Name** | **Description** |
| `other` | `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.Dialect` |

## Properties

### AzureSynapseDialect

    public AzureSynapseDialect AzureSynapseDialect { get; set; }

The Azure Synapse dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.AzureSynapseDialect` |   |

### BigqueryDialect

    public BigQueryDialect BigqueryDialect { get; set; }

The BigQuery dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.BigQueryDialect` |   |

### Db2Dialect

    public DB2Dialect Db2Dialect { get; set; }

DB2 dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.DB2Dialect` |   |

### DialectValueCase

    public Dialect.DialectValueOneofCase DialectValueCase { get; }

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.Dialecthttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.Dialect.DialectValueOneofCase` |   |

### GreenplumDialect

    public GreenplumDialect GreenplumDialect { get; set; }

Greenplum dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.GreenplumDialect` |   |

### HiveqlDialect

    public HiveQLDialect HiveqlDialect { get; set; }

The HiveQL dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.HiveQLDialect` |   |

### MysqlDialect

    public MySQLDialect MysqlDialect { get; set; }

The MySQL dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.MySQLDialect` |   |

### NetezzaDialect

    public NetezzaDialect NetezzaDialect { get; set; }

The Netezza dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.NetezzaDialect` |   |

### OracleDialect

    public OracleDialect OracleDialect { get; set; }

The Oracle dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.OracleDialect` |   |

### PostgresqlDialect

    public PostgresqlDialect PostgresqlDialect { get; set; }

The Postgresql dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.PostgresqlDialect` |   |

### PrestoDialect

    public PrestoDialect PrestoDialect { get; set; }

The Presto dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.PrestoDialect` |   |

### RedshiftDialect

    public RedshiftDialect RedshiftDialect { get; set; }

The Redshift dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.RedshiftDialect` |   |

### SnowflakeDialect

    public SnowflakeDialect SnowflakeDialect { get; set; }

The Snowflake dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.SnowflakeDialect` |   |

### SparksqlDialect

    public SparkSQLDialect SparksqlDialect { get; set; }

The SparkSQL dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.SparkSQLDialect` |   |

### SqlServerDialect

    public SQLServerDialect SqlServerDialect { get; set; }

The SQL Server dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.SQLServerDialect` |   |

### SqliteDialect

    public SQLiteDialect SqliteDialect { get; set; }

SQLite dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.SQLiteDialect` |   |

### TeradataDialect

    public TeradataDialect TeradataDialect { get; set; }

The Teradata dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.TeradataDialect` |   |

### VerticaDialect

    public VerticaDialect VerticaDialect { get; set; }

The Vertica dialect

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Migration.V2/latest/Google.Cloud.BigQuery.Migration.V2.VerticaDialect` |   |