https://community.databricks.com/t5/data-engineering/what-is-generated-columns-in-delta-table/m-p/17812#M11758 Mon, 28 Jun 2021 13:33:54 GMT User16826994223 2021-06-28T13:33:54Z https://community.databricks.com/t5/data-engineering/what-is-generated-columns-in-delta-table/m-p/17812#M11758 Mon, 28 Jun 2021 13:33:54 GMT https://community.databricks.com/t5/data-engineering/what-is-generated-columns-in-delta-table/m-p/17812#M11758 User16826994223 2021-06-28T13:33:54Z https://community.databricks.com/t5/data-engineering/what-is-generated-columns-in-delta-table/m-p/17813#M11759 <P>which are a special type of column whose values are automatically generated based on a user-specified function over other columns in the Delta table. You can use most built-in SQL functions to generate the values of these generated columns. For example, you can automatically generate a date column (for partitioning the table by date) from the timestamp column; any writes into the table need only specify the data for the timestamp column. You can create Delta tables with generated columns using SQL, Scala, Java or Python APIs.</P><P></P><P><A href="https://docs.databricks.com/delta/delta-batch.html#use-generated-columns" target="test_blank">https://docs.databricks.com/delta/delta-batch.html#use-generated-columns</A></P><P></P> Mon, 28 Jun 2021 13:35:10 GMT https://community.databricks.com/t5/data-engineering/what-is-generated-columns-in-delta-table/m-p/17813#M11759 User16826994223 2021-06-28T13:35:10Z