jeanmidevacc · August 26, 2025 03:29
diff --git a/databricks_get_version_delta_table.py b/databricks_get_version_delta_table.py
 # How to colect table versions
 query = f"""
 SELECT * 
 FROM (DESCRIBE HISTORY name_of_the_table)
 WHERE timestamp >= '{start_date.strftime('%Y-%m-%d %H:%M:%S')}';
 """

 # How to get a specific version
 dfs_recommendations = spark.read.format("delta").option("versionAsOf", version_id).table(f"name_of_the_table")
	# How to colect table versions
	query = f"""
	SELECT *
	FROM (DESCRIBE HISTORY name_of_the_table)
	WHERE timestamp >= '{start_date.strftime('%Y-%m-%d %H:%M:%S')}';
	"""

	# How to get a specific version
	dfs_recommendations = spark.read.format("delta").option("versionAsOf", version_id).table(f"name_of_the_table")