- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2023 03:15 AM
@amruth If you're working with data from SAP in Databricks and want to retrieve timestamps dynamically from a SAP table, you can utilize Databricks SQL to achieve this. You'll need to identify the specific SAP table that contains the timestamp or historical data. Once you've identified the table, you can construct a SQL query in Databricks that includes the appropriate columns and conditions to retrieve the timestamp dynamically. Consider using the SELECT statement to fetch the relevant timestamp column and apply any necessary filters based on your requirements. It's crucial to understand the structure of your SAP table and the naming conventions used for timestamp columns. If there's a specific column indicating historical data, you can use it in your query to retrieve timestamps dynamically. Ensure your Databricks environment is properly configured to connect to your SAP data source, and test your SQL query iteratively to ensure accurate results.