System Procedures Index

Procedures in SYS

• getXMLSchemas deprecated

Procedures in SYSADMIN

• addCliTemplate

• addRole

• addSystemProperty

• addUser

• addUserRole

• allowUserLogin

• batchUpdate

• changeCopyOverSourceTableJob

• changeCopyOverSQLJob

• changeIncrementalOptimizationJob

• changeJobParameters

• changeOptimizationJob

• changeResourceOwnerAndExecutor

• changeSQLJob

• changeUserPwd

• checkSortOrder

• cleanOrphanMatTableEntities

• cleanOrphanRemark

• cleanOrphanRemarks

• cleanupJobQueue

• cleanUpStaleMatTables

• clearResultSetCache

• copyOver

• copyPermissions

• createBackupJob

• createCleanupTaskIfAbsent

• createConnection

• createCreationParam

• createCopyOverSourceTableJob

• createCopyOverSQLJob

• createDataSource

• createGatherStatisticsJob

• createIncrementalOptimizationJob

• createIndex

• createOptimization

• createOptimizationJob

• createOptimizationQuery

• createOrReplaceDatasource

• createQueueHandler

• createSchedule

• createSQLJob

• createVirtualSchema

• deleteOptimization

• deleteRole

• deleteSchedule

• deleteSchedulerJob

• deleteSlackNotification

• deleteStatistics

• deleteSystemProperty

• deleteUser

• deleteUserRole

• deployModularConnector

• disableJobEmailNotification

• disableJobSlackNotification

• dropCliTemplate

• dropConnection

• dropCreationParam

• dropDataSource

• dropIndex

• dropIndexById

• dropIndexByName

• dropQueueHandler

• dropVirtualSchema

• editBackupJob

• editCliTemplate

• editCreationParam

• editQueueHandler

• editSystemProperty

• enableJobEmailNotification

• enableJobSlackNotification

• enableOptimization

• enableSchedule

• enableSchedulerJob

• execExternalProcess

• executeCli

• gatherStatistics

• getAllDataSourcesMetadataDiff

• getAuthMechanism

• getCatalogs

• getClientSecret

• getConnProp

• getCreateTempTablesPermissions

• getCurrentDWH

• getCurrentUser

• getCurrentVdb

• getDataCatalogAttribute

• getDataLineage

• getDataLineageRelationsOnly

• getDataSourceMetadataDiff

• getDataSourcePropertiesHierarchy

• getDefaultOptionValue

• getDriverLogos

• getEncryptedUserPwd

• getGeneratedColumnNames

• getInstalledLicense

• getJobProperty

• getJwtToken

• getReplicatedTableDiff

• getResourceDependencies

• getSchemas

• getServerBuildInfo

• getServerVersion

• getSchemaTmpValue

• getSchemaVersion

• getTypeOfResource

• getViewAndProcCreationOrder

• getXMLSchemas deprecated

• gitCheckout

• gitClone

• gitCommit

• gitDeploy

• gitDiff

• gitExclude

• gitFixConflict

• gitInit

• gitPull

• gitPush

• gitSetRemote

• gitStatus

• hasPermission

• historyUpdate

• importConnection

• importDataSource

• importFunction

• importIndex

• importMatTable

• importOptimization

• importProcedure

• importRecOptSymbol

• importSmtpConfiguration

• importUser

• importView

• isLoggable

• killQuery

• killSession

• leakyBucketReset

• leakyBucketTryConsume

• logMsg

• md5

• purgeObjects

• recreateConnection

• refreshAllDataSources

• refreshAllSchemas

• refreshDataSource

• refreshLdapUserCache

• refreshMatView deprecated

• refreshMatViewRow deprecated

• refreshOptimizations

• refreshSchema

• refreshSSOUserCache

• refreshTables

• removeConnection

• removeDataCatalogAttribute

• removeDataSource

• renameRole

• renameUser

• renameVirtualSchema deprecated

• reservedWords

• resetAtomicSchedule deprecated

• resetCliTemplates

• resetSchedule

• sendLicenseFile

• sendOracleADWCWallet obsolete

• sendSlackNotification

• setAllowCreateTempTables

• setColumnStats

• setCurrentDWH

• setDataCatalogAttribute

• setDefaultOptionValue

• setIndexStatus

• setJobProperty

• setOptimizationFrequency

• setPermissions

• setProperty

• setRecOptAllowIndexCreationByType

• setRecOptAllowIndexCreationByStatus

• setRemark

• setSchemaTmpValue

• setSmtpConfiguration

• setTableStats

• setUserLimits

• setUserTimezone

• startJob

• stopJob

• sleep

• testConnection

• translateColumnName

• translateColumnExpr

• updateMetastoreCredentials

• updateSchedule

• webBusinessDataShopPublish

• webBusinessDataShopUnpublish

• writeConnProp

Procedures in SYSADMIN_VDB

• createSSHKeyPair

• createSSHTunnel

• createVdb

• dropVdb

• generateCloudAgentApiKey

• getCloudAgentConfiguration

• getCloudAgentConnectionStatus

• getJavaProp

• importSSHKeyPair

• importSSHTunnel

• removeSSHKeyPair

• removeSSHTunnel

• renameSSHKeyPair

• setJavaProp

• updateCloudAgentConfiguration

Procedures in SYSLOG

• clearFinishedJobLogs

• clearHistory

• clearJobLogs

• clearPerformanceLogs

• clearQueryLogs

• getQueryLogPlan

• getQueryLogDataLineage

Procedures in UTILS

• arrayToTable

• cleanTable

• convertCSVtoTable

• createTable

• csvExport

• detect_file_encoding

• displayRuntime

• download_sftp

• fillSchemaWhenUsingFullSchemaName

• formatTableName

• getIncorrectUpdateColumns

• getModularConnectorDatasourceCreateStatement

• getOrderByColumns

• getSmtpConfiguration

• getTableIntersection

• importSmtpConfiguration

• incrementalReplication

• internal_expandProperties

• isBigQueryTable

• parsePropertiesString

• prepareTargetTable

• returnExtremeValue

• sendCsvExport

• sendMail

• setSmtpConfiguration

• tableExists

• tableToJson

• tableToXml

• tryCast

• tryCastDate

• tryCastTimestamp

• unzip

• upload_sftp

• upsert