Hi, I'm Bolo!
What would you like to know?
ASK BOLOPreview
Please to access Bolo.

Table of Contents

Search

  1. Introduction to Databricks Delta Connector
  2. Connections for Databricks Delta
  3. Mappings and mapping tasks with Databricks Delta connector
  4. Databricks Delta pushdown optimization (SQL ELT)
  5. Data type reference

Databricks Delta Connector

Databricks Delta Connector

Functions with Databricks Delta

Functions with Databricks Delta

When you use pushdown optimization,
Data Integration
converts the expression in the transformation by determining equivalent functions in the database. If there is no equivalent function,
Data Integration
processes the transformation logic.
The following table summarizes the availability of pushdown functions that you can push to the Databricks Delta database by using full or source pushdown optimization:
Function
Function
ABS()
MIN()
ASCII()
POWER()
AVG()
RAND()
CEIL()
REG_EXTRACT()
CHR()
REG_MATCH()
CONCAT()
REG_REPLACE()
COSH()
REPLACESTR()
COUNT()
REPLACECHR()
DECODE()
REVERSE()
FIRST()
ROUND(NUMBER)
GET_DATE_PART()
RPAD()
GREATEST()
RTRIM()
IN()
SQRT()
INITCAP()
STDDEV()
INSTR()
SUBSTR()
IS_DATE()
SUM()
IS_NULL()
SYSTIMESTAMP()
IS_NUMBER()
TANH()
IS_SPACES()
TO_BIGINT
LAST()
TO_CHAR(DATE)
LAST_DAY()
TO_CHAR(NUMBER)
LENGTH()
TO_DATE()
LN()
TO_DECIMAL()
LOWER()
TO_FLOAT()
LPAD()
TO_INTEGER()
LTRIM()
TRUNC(DATE)
MAX()
UPPER()
MD5()
VARIANCE()

0 COMMENTS

We’d like to hear from you!