ENUMDBTYPE

Specifies the database dialect or engine used by the data source.

List of ENUMDBTYPE

NameDescription
MSSQLMicrosoft SQL Server.
PostgreSQLPostgreSQL database dialect.
MySQLMySQL database dialect.
SQLiteSQLite embedded database.
OracleOracle database.
MariaDBMariaDB database.
SnowflakeSnowflake cloud data warehouse.
BigQueryGoogle BigQuery analytics database.

Examples

	
MODULE
    MODEL
        DATA FROM DATABASE
            DbType = MSSQL
            ConnectionName = 'CustomerDB'
            SQL = '
                SELECT
                    SentimentScore,
                    IssueSeverityScore,
                    WaitTime,
                    CustomerAge,
                    RuleAction
                FROM CustomerInteractions
            '