<?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 Delta sharing recipient auth status in Data Engineering</title>
    <link>https://community.databricks.com/t5/data-engineering/delta-sharing-recipient-auth-status/m-p/119588#M45923</link>
    <description>&lt;P&gt;I'm creating recipients, and send them activation link via email. All recipients are external (they don't have databricks account). Lets say I've created 300 recipients and I want to know who downloaded creds fail successfully, and got authenticated.&amp;nbsp;&lt;/P&gt;&lt;P&gt;At this moment I can monitor this status only in UI, for those who still don't download creds this status shows "Pending".&lt;/P&gt;&lt;P&gt;In DESCRIBE RECIPIENT command output I don't see any details about activation status&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Is there any way how can I get statuses for all recipients programmatically?&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;</description>
    <pubDate>Mon, 19 May 2025 08:31:38 GMT</pubDate>
    <dc:creator>drag7ter</dc:creator>
    <dc:date>2025-05-19T08:31:38Z</dc:date>
    <item>
      <title>Delta sharing recipient auth status</title>
      <link>https://community.databricks.com/t5/data-engineering/delta-sharing-recipient-auth-status/m-p/119588#M45923</link>
      <description>&lt;P&gt;I'm creating recipients, and send them activation link via email. All recipients are external (they don't have databricks account). Lets say I've created 300 recipients and I want to know who downloaded creds fail successfully, and got authenticated.&amp;nbsp;&lt;/P&gt;&lt;P&gt;At this moment I can monitor this status only in UI, for those who still don't download creds this status shows "Pending".&lt;/P&gt;&lt;P&gt;In DESCRIBE RECIPIENT command output I don't see any details about activation status&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Is there any way how can I get statuses for all recipients programmatically?&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 19 May 2025 08:31:38 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/delta-sharing-recipient-auth-status/m-p/119588#M45923</guid>
      <dc:creator>drag7ter</dc:creator>
      <dc:date>2025-05-19T08:31:38Z</dc:date>
    </item>
    <item>
      <title>Re: Delta sharing recipient auth status</title>
      <link>https://community.databricks.com/t5/data-engineering/delta-sharing-recipient-auth-status/m-p/119591#M45925</link>
      <description>&lt;P&gt;Hey&amp;nbsp;&lt;a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/103503"&gt;@drag7ter&lt;/a&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P class="" data-unlink="true"&gt;You’re absolutely right, currently, there is &lt;SPAN class=""&gt;&lt;STRONG&gt;no official API field that explicitly returns the recipient activation status &lt;/STRONG&gt;(I just have tested it)&lt;/SPAN&gt;, even though the &lt;A href="https://docs.databricks.com/api/workspace/recipients/list.html" target="_blank" rel="noopener"&gt;Databricks API documentation&lt;/A&gt; references a field called&lt;SPAN class=""&gt;&amp;nbsp;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;activated&lt;/STRONG&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;FONT color="#FF0000"&gt;&amp;nbsp;&lt;SPAN class=""&gt;&lt;STRONG&gt;boolean&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P class=""&gt;In practice, &lt;SPAN class=""&gt;&lt;STRONG&gt;this field is not returned&lt;/STRONG&gt;&lt;/SPAN&gt; by the &lt;SPAN class=""&gt;GET /api/2.1/unity-catalog/recipients&lt;/SPAN&gt; endpoint, nor is it shown in the output of &lt;SPAN class=""&gt;DESCRIBE RECIPIENT &amp;lt;name&amp;gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;H3&gt;&lt;STRONG&gt;What we’ve observed as a workaround:&lt;/STRONG&gt;&lt;/H3&gt;&lt;P class=""&gt;When a recipient is created with &lt;SPAN class=""&gt;authentication_type = "TOKEN"&lt;/SPAN&gt;, the API response and DESCRIBE RECIPIENT includes a field under the token object:&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;"activation_url": "https://...retrieve_config.html?..."&lt;/LI-CODE&gt;&lt;UL&gt;&lt;LI&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;This &lt;/SPAN&gt;&lt;SPAN class=""&gt;activation_url&lt;/SPAN&gt;&lt;SPAN class=""&gt; exists &lt;/SPAN&gt;&lt;STRONG&gt;only before the recipient has activated (i.e., downloaded) the credentials&lt;/STRONG&gt;&lt;SPAN class=""&gt;.&lt;/SPAN&gt;&lt;/P&gt;&lt;/LI&gt;&lt;LI&gt;&lt;P class=""&gt;&lt;STRONG&gt;Once the recipient uses the link, the &lt;SPAN class=""&gt;activation_url&lt;/SPAN&gt; field disappears from the token, and that’s currently the only reliable signal that the recipient has completed activation.&lt;/STRONG&gt;&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P class=""&gt;So, you can use the &lt;SPAN class=""&gt;recipients/list&lt;/SPAN&gt; API to fetch all recipients, and programmatically check which still include the &lt;SPAN class=""&gt;activation_url&lt;/SPAN&gt; field.&lt;/P&gt;&lt;P class=""&gt;This behavior is &lt;SPAN class=""&gt;&lt;STRONG&gt;not officially documented&lt;/STRONG&gt;&lt;/SPAN&gt;, and may change in future versions, but for now, it’s the most reliable way we’ve found to monitor recipient activation at scale without relying on the UI...&lt;BR /&gt;&lt;BR /&gt;Hope this helps, &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;&lt;BR /&gt;&lt;BR /&gt;Isi&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 19 May 2025 08:58:42 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/delta-sharing-recipient-auth-status/m-p/119591#M45925</guid>
      <dc:creator>Isi</dc:creator>
      <dc:date>2025-05-19T08:58:42Z</dc:date>
    </item>
  </channel>
</rss>

