DOUBLE

In the Ultra Transcenders books

DBX-DEP

Each book explains DOUBLE in context, with comparison tables and the common traps.

Terms in this definition

• Materialized view

  A view that stores its query output ahead of time. A serverless pipeline maintains it, refreshing it on demand with REFRESH MATERIALIZED VIEW, on a schedule or when upstream data changes, incrementally when it can.

• Full refresh

  A pipeline run that wipes the stored data and state of a streaming table or materialized view and then rebuilds it from every source record; anything already deleted at the source cannot come back.

• DECIMAL

  Use DECIMAL(p,s) for money or any figure where floating-point rounding would be wrong. Precision p can be 1 to 38 and is 10 if left out; scale s is 0 if left out.

Related terms

• Dynamic value reference

  A placeholder in double braces, such as {{job.parameters.<name>}}, that Lakeflow Jobs replaces at run time with details about the job or run, a parameter's value or a value passed on by an earlier task.

• FIELDQUOTE

  Sets the one character COPY INTO treats as the quote mark in CSV files, a double quote by default. Delimiters found between quotes are then kept as ordinary data.

• LangChain

  An open-source framework for LLM applications, connected to Databricks through databricks-langchain. Its prompt templates write variables in single braces, {variable}, whereas the registry uses double braces.

• Schema hints

  An Auto Loader setting that pins the types of particular columns, using SQL schema syntax such as id long, amount double, while the rest of the schema is still inferred. Hints may also declare columns that haven't appeared yet.

• Shares

  A relative weighting for dividing a contended resource such as memory, CPU, network bandwidth or disk I/O: double the shares earns double the entitlement. Reservations, by contrast, are guarantees and limits are ceilings.