phData

JULY 12, 2023

Unlike traditional methods that rely on complex SQL queries for orchestration, Matillion Jobs provides a more streamlined approach. By converting SQL scripts into Matillion Jobs , users can take advantage of the platform’s advanced features for job orchestration, scheduling, and sharing. With that, let’s dive in!

SQL 52

SQL ETL Database Data Pipeline 52

phData

OCTOBER 5, 2023

Hello, and welcome to our September phData Toolkit blog series update! Over the last month, we’ve been continuing to focus heavily on adding additional support for our Microsoft SQL Server to Snowflake SQL translations. For example, did you know that you can put spaces between a less-than-or-equals symbol in SQL Server?

SQL 52

SQL 52

phData

MARCH 31, 2023

Hello and welcome to the next monthly installation of the phData Toolkit blog series! You have tons of data and SQL to migrate, and you need to ensure that it’s done right, or it’s your job on the line! WIthin our Toolkit CLI, we primarily have two different tools: our SQL Translation Tool and our Data Source Tool.

SQL 52

SQL Data Profiling Data Pipeline Database 52

phData

JULY 29, 2023

Hello, and welcome to the latest installment of the phData Toolkit blog series. We’ve been focusing on two key areas: Microsoft SQL Server to Snowflake Data Cloud SQL translations and our new Advisor tool within the phData Toolkit. We hope you had a great time being with family and friends. Let’s dive in.

SQL 52

SQL Database Data Pipeline 52

phData

APRIL 21, 2023

Unlike traditional methods that rely on complex SQL queries for orchestration, Matillion Jobs provide a more streamlined approach. By converting SQL scripts into Matillion Jobs , users can take advantage of the platform’s advanced features for job orchestration, scheduling, and sharing. In our case, this table is “orders.”

SQL 52

SQL ETL Database Data Pipeline 52

phData

JUNE 6, 2023

Hello and welcome to the latest installment of our phData Toolkit blog series! Toolkit CLI Updates The Toolkit CLI is an extension of our Toolkit UI and aims to provide a programmatic interface for a variety of tasks such as SQL translation, profiling of source/target databases, and generating scripts using those profiles.

SQL 52

SQL Data Governance AWS Database 52

Towards AI

SEPTEMBER 28, 2023

Last Updated on September 29, 2023 by Editorial Team Author(s): Mihir Gandhi Originally published on Towards AI. With PySpark, you can write Python and SQL-like commands to manipulate and analyze data in a distributed processing environment. select: Projects a… Read the full blog for free on Medium. What is PySpark?

Apache Hadoop 73

Apache Hadoop Hadoop Python SQL 73

phData

MAY 14, 2024

Furthermore, we spread our knowledge throughout the internet, creating hundreds of blogs each year, just like this one, to help anyone working with Snowflake and other data engineering-related topics. The SQL Translation application instantly converts queries from one SQL dialect to another.

SQL 52

SQL Data Warehouse Data Engineering Data Engineer 52

Pickl AI

JANUARY 17, 2023

If you are a Data Science aspirant and want to know how to become a Data Scientist in 2023, this is your guide. The following blog post would naturally cover all the important aspects of becoming a Data Scientist including a step-by-step guide on the same. The post How to become a Data Scientist in 2023?

Data Scientist 52

Data Scientist Data Science Machine Learning Machine Learning 52

Dataversity

NOVEMBER 21, 2022

The new ISO 39075 Graph Query Language Standard is to hit the data streets in late 2023 (?). If graph databases are standardized pretty soon, what will happen to SQL? Not simply because legacy SQL has a tremendous inertia, but because relational database paradigms […]. They will very likely stay around for a long time.

SQL 52

SQL Database Data Modeling Data Models 52

phData

OCTOBER 16, 2023

Thanks to our team’s hard work and success with dbt, we achieved something remarkable: being named the dbt Labs’ 2023 Services Partner of the Year. In this blog, we’ll cover what winning this award means for our organization, how we achieved it, and more!

DataOps 52

DataOps Data Modeling Data Models SQL 52

IBM Journey to AI blog

MAY 31, 2023

The Presto Foundation is excited to share its upcoming virtual community conference PrestoCon Day , taking place on 7 June 2023. Presto is an open-source, fast and reliable SQL query engine that provides one simple ANSI SQL interface for all your data analytics and your open lakehouse.

SQL 91

SQL Analytics Analytics AI 91

Towards AI

JULY 21, 2023

Last Updated on July 21, 2023 by Editorial Team Author(s): Louis Chan Originally published on Towards AI. Because of its accessibility, NAS is one of the best solutions for sharing data across devices in the form of a database, be it relational or no-SQL. Join thousands of data leaders on the AI newsletter.

Database 40

Database SQL AI AI 40

ODSC - Open Data Science

AUGUST 17, 2023

Evolving Trends in Prompt Engineering, a Primer to Scaling Pandas, and Enriching ERP with Generative AI Evolving Trends in Prompt Engineering for Large Language Models (LLMs) with Built-in Responsible AI Practices In this blog post, our objective is to illuminate the constantly evolving research around the LLMs space, including prompt engineering.

Natural Language Processing 52

Natural Language Processing Artificial Intelligence Artificial Intelligence Data Science 52

AWS Machine Learning Blog

JUNE 13, 2023

The natural language capabilities allow non-technical users to query data through conversational English rather than complex SQL. The AI and language models must identify the appropriate data sources, generate effective SQL queries, and produce coherent responses with embedded results at scale.

Database 72

Database SQL AWS AI 72

phData

MARCH 27, 2024

As the proud recipient of the 2023 (and 2022) Snowflake Partner of the Year award, phData has a wealth of invaluable insights, best practices, tips, and learning strategies that were essential in my own journey of upskilling in Snowflake. In this blog, I’ll guide you towards success in your Snowflake learning journey.

Data Analyst 52

Data Analyst Data Engineering Data Engineer Data Engineering 52

Towards AI

JULY 20, 2023

Last Updated on July 20, 2023 by Editorial Team Author(s): Harsh Darji Originally published on Towards AI. I have also found opportunities within my company to develop my analytical skills (SQL, data viz, business case, scripting). Data Science The minimal effort maximum outcome way Happiness is not pleasure.

Data Science 88

Data Science SQL Data Scientist Algorithm 88

IBM Journey to AI blog

OCTOBER 17, 2023

In a research brief defining “5 trends for 2023,” the IBM Institute for Business Value reports, “In 2023, rapid response is the new baseline. Uncertainty is expected and complexity is compounding. As threats materialize on multiple fronts, organizations must reduce the time from insight to action.”

Data Analyst 83

Data Analyst Business Intelligence Business Intelligence SQL 83

phData

FEBRUARY 29, 2024

it has to be done using custom SQL in Tableau? Hopefully, you don’t run into this scenario because joining and querying multiple tables in Tableau using custom SQL is not recommended due to its impact on performance. Hopefully these tips and examples will give you a kick start in your SQL optimization journey.

Tableau 52

Tableau SQL Database ETL 52

IBM Journey to AI blog

SEPTEMBER 1, 2023

According to the IBM Security X-Force Threat Intelligence Index 2023 , ransomware attacks represented 17 percent of all cyberattacks in 2022. Cross-site scripting (XSS) —these type of attacks are similar to SQL injection attacks, except instead of extracting data from a database, they typically infect users who visit a website.

SQL 112

SQL Database Internet of Things Machine Learning 112

phData

MARCH 18, 2024

In this blog, we will explore Slowly Changing Dimensions (SCDs) and the magic of dbt snapshots. product_id product_name category price update_date 1 MacBook Air (15-inch, M2, 2023) Computers & Accessories $999 June 13, 2023 In the product table, we have a product, MacBook Air (15-inch, M2, 2023), and the price is $999 as of June 13, 2023.

Data Warehouse 52

Data Warehouse SQL Data Pipeline Analytics 52

phData

JULY 3, 2023

One of the hottest announcements at Snowflake Summit 2023 was the launch of Hex on Snowpark Container Services. In this blog, we’ll introduce what Hex on Snowpark Container Services is and its benefits for data science, machine learning, and analytics. What is Hex? Hex is a rich development environment for modern analytics.

Analytics 52

Analytics Analytics Python SQL 52

phData

JULY 19, 2023

In this blog post, we’ll explore the creation, deployment, and testing of a Snowpark stored procedure using Python within the recently introduced Python worksheets in Snowsight. Snowflake has been enhancing worksheets with Snowsight in 2023, and customers are slowly adapting to the new Snowsight from last year. What is Snowsight?

Python 52

Python SQL Database 52

phData

JULY 19, 2023

In this blog post, we’ll explore the creation, deployment, and testing of a Snowpark stored procedure using Python within the recently introduced Python worksheets in Snowsight. Snowflake has been enhancing worksheets with Snowsight in 2023, and customers are slowly adapting to the new Snowsight from last year. What is Snowsight?

Python 52

Python SQL Database 52

phData

JUNE 8, 2023

In this blog, we will provide an introduction to Power BI Report Builder, explore its purpose, interface, and available data connections, and discuss certain limitations. Available Data Source Connections At the time this blog post was written, Power BI Report Builder was somewhat limited in its data source connection options.

Power BI 90

Power BI SQL Azure Database 90

ODSC - Open Data Science

MARCH 6, 2023

In the first blog, we’re going to discuss the technical side of things, such as what languages and platforms people are using. For the last part of the first blog in this series, we asked about what areas of the field data scientists are interested in as part of the machine learning survey.

Machine Learning 116

Machine Learning Machine Learning Deep Learning Deep Learning 116

phData

NOVEMBER 1, 2023

This blog was originally written by Keith Smith and updated for 2023/2024 by Justin Delisi. In this blog, we will explore how to effectively estimate costs within the Snowflake data warehousing environment, help determine a baseline of costs with Snowflake, and explore a few key features that will add to your costs.

Data Warehouse 52

Data Warehouse SQL Database Cloud Computing 52

Pickl AI

FEBRUARY 6, 2023

Preparing for the SQL interview questions to become more proficient in data science with example questions and a framework for answering them. Amongst the different tools that data scientists must have in their arsenal, SQL holds a special significance. This phase of the interview demands you to address real-world problems using SQL.

SQL 52

SQL Data Analyst Data Science Database 52

phData

NOVEMBER 30, 2023

For example, you can use alerts to send notifications, capture data, or execute SQL commands when certain events or thresholds are reached in your data. In this blog, we will go over how to create alerts in Snowflake, explaining the necessary privileges, how to configure the alert parameters, and how to monitor alert history.

SQL 52

SQL Cloud Data Database ETL 52

Towards AI

NOVEMBER 3, 2023

Last Updated on November 5, 2023 by Editorial Team Author(s): Pere Martra Originally published on Towards AI. We will use this capability to create a prompt that allows OpenAI Models to generate SQL commands from Natural Language. That is, translating user language requests into SQL commands that will retrieve the requested data.

SQL 119

SQL AI AI Machine Learning 119

ODSC - Open Data Science

MAY 11, 2023

In this blog post, we unravel the truth behind the buzz and reveal the limitations that make this project unsuitable for real-world applications. 5 Things I Learned Writing SQL with Gen AI DataDistillr has found some interesting uses for generative AI. Databases for the Era of Artificial Intelligence Everyone is talking about ChatGPT.

AI 52

AI AI Azure Data Science 52

phData

MARCH 21, 2023

In this blog post, we will explore the capabilities of Snowpark with Hex and provide guidance on how to use these tools for your own machine-learning projects using a sample data set from Snowflake. All of these commands are translated into SQL and pushed down to the Snowflake warehouse. Want to learn more? Can’t wait?

Machine Learning 52

Machine Learning Machine Learning Database ML 52

phData

SEPTEMBER 7, 2023

Hello, and welcome to our August update of the phData Toolkit blog series! Over the last month, we’ve been heavily focused on adding additional support for SQL translations to our SQL Translations tool. Over the last month, we’ve been heavily focused on adding additional support for SQL translations to our SQL Translations tool.

SQL 52

SQL Data Profiling Data Pipeline Database 52

IBM Journey to AI blog

NOVEMBER 29, 2023

In 2023, the IBM® Institute for Business Value (IBV) surveyed 2,500 global executives and found that best-in-class companies are reaping a 13% ROI from their AI projects—more than twice the average ROI of 5.9%. Learn more about how you can build or enhance your own complete, composable enterprise-wide event-driven architecture.

Artificial Intelligence 92

Artificial Intelligence Artificial Intelligence Apache Kafka AI 92

phData

MARCH 31, 2023

In this blog, we will dive deeper into the capabilities of Snowpark for Python and how combining with Hex supports data science by providing faster and more efficient data processing and analytics capabilities on top of Hex’s easy notebook collaboration and sharing. Check out these blogs and reach out to our Data Science and ML team!

Data Science 59

Data Science Machine Learning Machine Learning ML 59

phData

JUNE 26, 2023

Welcome to the latest installment of the phData Toolkit blog series! in this June episode of the blog. While many of our customers leverage our UI for tools like our SQL Translation or Privilege Audit tooling, there are limitations when it comes to using a UI. We’re already halfway through the year (crazy, right?!)

SQL 52

SQL Data Profiling Data Pipeline Data Governance 52

ODSC - Open Data Science

AUGUST 24, 2023

In this blog post, our objective is to illuminate the constantly evolving research around the LLMs space, while also addressing key ethical considerations and trying to provide practical guidance to AI practitioners and clients with examples of our internal use cases, facilitating the responsible development of LLM applications.

Artificial Intelligence 52

Artificial Intelligence Artificial Intelligence Natural Language Processing AI 52