User ID, Username and Notebook not populated in History Tab

[GMB]

Hi,

If I update a Tag on a table within a Noetbook as follows:

sql = f"""ALTER TABLE {silver_catalog}.public.tablename SET TAGS ('Is_published' = 'Y');"""

spark.sql(sql)

Then the User ID and Username, nor Notebook is populated when I look in the History tab after executing the code.

User ID and Username are capyured if I manually make the updates via the UI.
Is this by design or do I need to do something else to capture this information?

[Kaniz_Fatma]

Hi @GMB , It seems like you’re trying to capture the User ID and Username in the history tab of a notebook after executing some SQL code.

Typically, the User ID and Username are captured when changes are made via the User Interface (UI), as these changes are associated with a user action. However, when you execute code within a notebook, the changes are made by the system, not a specific user, so the User ID and Username might not be automatically captured.

To capture this information, you might need to manually add code to log the User ID and Username along with the changes. For example, you could modify your code to include logging statements that record the User ID and Username each time a change is made.

However, this behaviour can vary depending on the specific notebook environment you’re using. If you’re using Databricks, for instance, you might be able to retrieve some information about the n.... 

This could potentially include the User ID and Username, depending on the specific context attributes available in your environment.

[Kaniz_Fatma]

Hey there! Thanks a bunch for being part of our awesome community! 🎉 

We love having you around and appreciate all your questions. Take a moment to check out the responses – you'll find some great info. Your input is valuable, so pick the best solution for you. And remember, if you ever need more help , we're here for you! 

Keep being awesome! 😊🚀