<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic SQL endpoint querying table changes using a greater timestamp or version than the last table commit in Data Engineering</title>
    <link>https://community.databricks.com/t5/data-engineering/sql-endpoint-querying-table-changes-using-a-greater-timestamp-or/m-p/4115#M920</link>
    <description>&lt;P&gt;Reading table changes using a greater timestamp or version than the last table commit throws an error and can be changed using a flag timestampOutOfRange.enabled,&lt;/P&gt;&lt;P&gt;My issue is that I use an &lt;B&gt;SQL endpoint&lt;/B&gt; and&amp;nbsp;I don't see any way of providing this spark flag&lt;/P&gt;&lt;PRE&gt;&lt;CODE&gt;from table_changes(
      'table_name',
      '2023-05-17' -- greater then latest table commit
)&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&lt;A href="https://docs.databricks.com/delta/delta-change-data-feed.html" target="test_blank"&gt;https://docs.databricks.com/delta/delta-change-data-feed.html&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;</description>
    <pubDate>Sun, 21 May 2023 05:49:30 GMT</pubDate>
    <dc:creator>avivshafir</dc:creator>
    <dc:date>2023-05-21T05:49:30Z</dc:date>
    <item>
      <title>SQL endpoint querying table changes using a greater timestamp or version than the last table commit</title>
      <link>https://community.databricks.com/t5/data-engineering/sql-endpoint-querying-table-changes-using-a-greater-timestamp-or/m-p/4115#M920</link>
      <description>&lt;P&gt;Reading table changes using a greater timestamp or version than the last table commit throws an error and can be changed using a flag timestampOutOfRange.enabled,&lt;/P&gt;&lt;P&gt;My issue is that I use an &lt;B&gt;SQL endpoint&lt;/B&gt; and&amp;nbsp;I don't see any way of providing this spark flag&lt;/P&gt;&lt;PRE&gt;&lt;CODE&gt;from table_changes(
      'table_name',
      '2023-05-17' -- greater then latest table commit
)&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&lt;A href="https://docs.databricks.com/delta/delta-change-data-feed.html" target="test_blank"&gt;https://docs.databricks.com/delta/delta-change-data-feed.html&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;</description>
      <pubDate>Sun, 21 May 2023 05:49:30 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/sql-endpoint-querying-table-changes-using-a-greater-timestamp-or/m-p/4115#M920</guid>
      <dc:creator>avivshafir</dc:creator>
      <dc:date>2023-05-21T05:49:30Z</dc:date>
    </item>
  </channel>
</rss>

