tag:blogger.com,1999:blog-85110400515380266632026-08-30T00:44:08.950-07:00This is my technical area for troubleshooting and learning new programming skills and much more. Here, you will find answers on a wide range of technologies such as AI, Machine Learning, OpenAI, Databricks, ASP.NET, C#, Python, Microsoft Access, MySQL, Amazon Web Services, SQL Server, PL/SQL, JD Edwards, SAS, Salesforce, APIs, MVC, and many others. Please feel free to visit and join the discussion!Rajeevhttp://www.blogger.com/profile/07798219622368263263noreply@blogger.comBlogger1678125tag:blogger.com,1999:blog-8511040051538026663.post-61730087800660712212025-09-06T06:44:00.000-07:002025-09-06T06:44:48.634-07:00

1) Security mapping table (who can see what)-- Use your real catalog/schema names CREATE SCHEMA IF NOT EXISTS prod_catalog.security; CREATE TABLE IF NOT EXISTS prod_catalog.security.user_security_gl ( user_email STRING COMMENT 'AAD/Okta sign-in email shown to Databricks', co STRING COMMENT 'Company code the user may see (use * for all)', -- add more dims if needed, e.g. state

Rajeevhttp://www.blogger.com/profile/07798219622368263263noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-32947294549578523202025-08-07T12:30:00.000-07:002025-08-07T12:30:02.808-07:00

Introducing GPT‑5: A Smarter, Faster, More Helpful AI 🛒 Explore Smart Assistants on Amazon A Leap in Unified AI Intelligence OpenAI’s GPT‑5 introduces a groundbreaking unified reasoning system—smart enough to choose between quick answers and deep insights. It mimics human decision-making with stunning accuracy. 🛒 Shop AI-Powered Devices Thinking Smarter, Performing Better Coding:

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-86826149808753883912025-08-06T22:27:00.000-07:002025-08-06T22:36:19.522-07:00

 The gpt‑oss‑120b is one of OpenAI’s newly released open‑weight large language models (as of August 2025). It is designed to offer high reasoning and coding performance, while being freely available for download and use, including fine-tuning and commercial deployment. 🔍 Overview of gpt‑oss‑120b Feature Description Model type Mixture-of-Experts (MoE) Total parameters ~120 billion

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-76307139235616618522025-08-04T11:53:00.000-07:002025-08-04T11:53:51.501-07:00

 How to create databricks View with COMMENT in column for AI useCREATE OR REPLACE VIEW prod_catalog.mrt_corp.testvwdata (  STATEID STRING COMMENT 'State ID',  AFFILIATIONID STRING COMMENT 'Affiliation ID',  AGE INT COMMENT 'Age',  AGE_CAT STRING COMMENT 'Age Category') ASSELECT   STATEID,  AFFILIATIONID,  AGE,  AGE_CATFROM prod_catalog.mrt_corp.MM;

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-47491042400434168592025-07-17T21:39:00.000-07:002025-07-17T22:30:29.116-07:00

🚀 Building a ChatGPT Agent for GAAP Reporting – Step-by-Step Guide In the age of AI-powered automation, GAP reporting—identifying differences between forecasted and actual results—can be dramatically simplified using a custom ChatGPT agent. Whether you're in Finance, Operations, or Analytics, building your own ChatGPT GAP Reporting Agent can save hours of manual analysis and enable data-driven

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-81208493947033220192025-07-13T08:18:00.000-07:002025-07-13T08:18:47.795-07:00

As a seasoned leader in data analytics and financial systems, I specialize in leveraging artificial intelligence to transform finance and accounting operations. With a strong background in both technology and business strategy, I have led the successful development and deployment of intelligent automation tools that streamline processes, enhance decision-making, and drive measurable impact across

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-40657921847852502832025-07-08T13:43:00.000-07:002025-07-08T13:43:29.381-07:00

🔥 Databricks Stored Procedures: A Game-Changer for Lakehouse SQL In late 2023, Databricks quietly rolled out a powerful feature: Stored Procedures for SQL workloads. This brings traditional database development workflows right into the Lakehouse architecture. Until recently, tasks like reusable logic, transactional operations, or parameterized transformations required complex workarounds. Now,

Rajeevhttp://www.blogger.com/profile/07798219622368263263noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-19207598336699404672025-07-03T20:40:00.000-07:002025-07-03T20:40:15.234-07:00

Imagine a world where IT tickets don’t sit idle in queues, but are instantly read, understood, and addressed by intelligent automation. With our AI-powered Jira integration using OpenAI and Databricks, we’re transforming how support issues are resolved. As soon as a user submits a ticket, the system fetches it using the Jira API, analyzes the issue using GPT-based AI, and proposes a

Rajeevhttp://www.blogger.com/profile/07798219622368263263noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-77818126226031658212025-06-29T14:10:00.000-07:002025-06-29T14:10:46.607-07:00

 The error you're seeing — "Cannot create serverless connection, try again later" — usually occurs in Databricks Community (free) edition because serverless SQL endpoints and premium features are not supported on that tier. 🔍 Why This Happens: Serverless SQL endpoints are part of Databricks SQL Pro or Enterprise tiers, and are not available in the Community Edition. The Community

Rajeevhttp://www.blogger.com/profile/07798219622368263263noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-4761763760923301052025-06-29T09:58:00.000-07:002025-06-29T09:58:31.326-07:00

🧠 Databricks Notebook Keyboard Shortcuts & Tricks Boost your productivity with these handy tips—plus gear recommendations for your data workspace! 🔑 Notebook Editor Shortcuts Action Shortcut (Windows/Linux) Shortcut (Mac) Run cell Shift + Enter Shift + Enter Run cell and insert below Alt + Enter Option + Enter Run all cells above Ctrl + Shift + ↑ Cmd + Shift + ↑ Run all cells

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-53997179802079530732025-06-29T09:45:00.000-07:002025-06-29T09:45:46.756-07:00

🔮 What's New in AI & Data Science – 2025 Trends Stay ahead of the curve with the most important innovations shaping AI, BI, and analytics this year. These advances are redefining how forecasting, automation, and insights are delivered across industries. 🔍 Retrieval-Augmented Generation (RAG) 2.0 What’s new: RAG models like GPT-4o integrate real-time external data sources (SQL,

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-34954349302769757812025-06-28T17:43:00.000-07:002025-06-28T17:43:17.706-07:00

 https://www.youtube.com/watch?v=22-VY8niW6Y

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-46180472159654460322025-06-14T15:00:00.000-07:002025-06-14T15:00:14.160-07:00

🧠 What is a Multi-Agent System? A Multi-Agent System (MAS) is a system composed of two or more intelligent agents that: Interact with each other (via messages, APIs, databases, etc.) Share or divide tasks May have different roles, goals, or knowledge Can work in parallel to increase performance and intelligence 🤖 Example of Multi-Agent Use Cases: Use Case Agents Involved What

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-39789287762148980292025-06-14T09:50:00.000-07:002025-06-14T09:50:06.271-07:00

Just returned from the Databricks AI 2025 Conference – and wow, the future is here. From AI-native assistants to zero-code data pipelines, Databricks is redefining how we work with data. Here are some of the highlights that blew me away: 🧞 Genie – An LLM-powered AI assistant built into the Lakehouse 🧠 LakehouseIQ 2.0 – Understands your data contextually, across silos 📥 Lakebase – Zero-code

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-58672037997146581252025-06-06T17:55:00.000-07:002025-06-06T17:58:17.385-07:00

 https://youtube.com/shorts/bprUUOOMDwcAgentic AI Books-  https://amzn.to/4lfgSjx

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-65715984390178859382024-10-16T11:21:00.000-07:002025-03-31T12:39:43.201-07:00

Convert date in Databricks - JD Edwards Julian date to calendar date CREATE FUNCTION yourdatabase.date_convert_j_to_c(gldgj INT)RETURNS TIMESTAMPRETURN date_sub(    date_add(        DAY,         cast(gldgj AS VARCHAR(10)) % 1000,         date_add(YEAR, cast(gldgj AS VARCHAR(10)) / 1000, cast('1900-01-01' AS timestamp))  &

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-29450744014613946292024-06-21T17:26:00.000-07:002024-06-21T17:26:16.553-07:00

https://studio.youtube.com/video/-L3NuOWGWwE/edit

Rajeev Kumarhttp://www.blogger.com/profile/11692241466462478872noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-23105761351625218492024-06-10T21:51:00.000-07:002024-06-10T21:51:38.708-07:00

Sub Upload_Data_To_SQLServer_Dynamic() ' Define variables Dim Cn As ADODB.Connection Dim rs As ADODB.Recordset Dim uploadQuery As String Dim batchCounter As Long Dim batchSize As Long Dim batchQuery As String Dim headerArray() As String Dim numColumns As Integer Dim columnList As String Dim sqlQuery As String Dim TableName As String Dim i As

Rajeev Kumarhttp://www.blogger.com/profile/11692241466462478872noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-39893471254056564512024-06-06T17:27:00.000-07:002024-06-06T17:29:10.819-07:00

 How to load data (CSV file) in databricks delta table using Excel, VBA and DSN1. Create DSN using Simba driver on your machine2. Get token and password from databricks3. CSV column header Name must be same as table's columns header. Sub UploadDataToSQLServer_Dynamic()    ' Define variables    Dim sFile As String    Dim Cn As ADODB.Connection   

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-22934650296234473802024-02-15T16:30:00.000-08:002024-02-15T16:31:19.681-08:00

A user-defined function (UDF) is a means for a user to extend the native capabilities of Apache Spark™ SQL. SQL on Databricks has supported external user-defined functions written in Scala, Java, Python and R programming languages since 1.3.0. While external UDFs are very powerful, they also come with a few caveats:Security. A UDF written in an external language can execute dangerous or even

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-59317416768037984452024-01-18T20:42:00.000-08:002024-01-18T20:42:15.691-08:00

Modern data platforms store and collect an incredible amount of both useful data and metadata. However, even knowing the metadata itself might be not useful for the end-users who don’t have enough experience with classical components of a relation-based data model. One of the challenges is not only the ability to write proper SQL statements to select the relevant information but also

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-5830867566259429822023-10-18T19:05:00.001-07:002023-10-18T19:05:21.772-07:00

COPY INTO delta.`abfss://container@storageAccount.dfs.core.windows.net/deltaTables/target` FROM (SELECT key, index, textData, 'constant_value' FROM 'abfss://container@storageAccount.dfs.core.windows.net/base/path') FILEFORMAT = CSV PATTERN = 'folder1/file_[a-g].csv' FORMAT_OPTIONS('header' = 'true') -- The example below loads CSV files without headers on ADLS Gen2 using COPY

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-47910924119277069862023-08-17T09:45:00.003-07:002023-08-17T09:45:25.105-07:00

 ALTER TABLE enterprise_db.tblmf_sources SET TBLPROPERTIES (  'delta.minReaderVersion' = '2',  'delta.minWriterVersion' = '5',  'delta.columnMapping.mode' = 'name')Alter table RENAME enterprise_db.tblmf_sources COLUMN     sourceName TO SourceName

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-59991490033672368622023-05-26T14:15:00.007-07:002023-05-26T14:15:38.443-07:00

Remove:- dbutils.widgets.removeAll() Add:- dbutils.widgets.text("EnterCaseNo", "17102603374")

Rajeevhttp://www.blogger.com/profile/04098009819405698705noreply@blogger.com0tag:blogger.com,1999:blog-8511040051538026663.post-12914150420902717422023-05-11T10:49:00.001-07:002023-05-11T10:49:22.402-07:00

This code generated by chat.openai.com and this code is for databricks notebook. I modified according to my need. %pythonimport openaiopenai.api_key = os.environ["OPENAI_API_KEY"] #prompt = "Write a news article about a new breakthrough in cancer research."#prompt = "Write a letter about cancer research. to a doctor "#prompt = "Write a letter to supervisor about leave"prompt =

Rajeevhttp://www.blogger.com/profile/07798219622368263263noreply@blogger.com0