Aimpoint Digital
Aimpoint Digital
  • Видео 25
  • Просмотров 196 207
Snowflake Cortex AI | How to Use the SUMMARIZE Function
In part 3 of our Snowflake Cortex AI series, Christopher Marland, a Snowflake Solutions Architect at Aimpoint Digital and a recognized Snowflake Data Superhero, presents an in-depth tutorial on Snowflake Cortex. This video focuses on the SUMMARIZE function.
For additional insights and to access the dataset used in this video, visit the following links:
movies file: 5527549.fs1.hubspotusercontent-na1.net/hubfs/5527549/Cortex%20AI%20-%20Summarize%20Video/movies%203.parquet
SUMMARIZE_incomplete file: 5527549.fs1.hubspotusercontent-na1.net/hubfs/5527549/Cortex%20AI%20-%20Summarize%20Video/SUMMARIZE_incomplete.ipynb
SUMMARIZE_completed file: 5527549.fs1.hubspotusercontent-na1.net/hubfs/5527549/Co...
Просмотров: 95

Видео

Snowflake Cortex AI | How to Use the COMPLETE Function
Просмотров 29421 день назад
In part 2 of our Snowflake Cortex AI series, Christopher Marland, a Snowflake Solutions Architect at Aimpoint Digital and a recognized Snowflake Data Superhero, delivers a tutorial on the COMPLETE function in Snowflake Cortex. This function allows you to integrate large language models (LLMs) into your SQL queries, offering a new level of AI-driven data interaction within Snowflake. Christopher...
Snowflake Cortex AI | How to Use (EXTRACT_ANSWER)
Просмотров 361Месяц назад
In part 1 of our Snowflake Cortex AI series, Christopher Marland, a Snowflake Solutions Architect at Aimpoint Digital and a recognized Snowflake Data Superhero, presents an in-depth tutorial on Snowflake Cortex. The tutorial focuses on the powerful (EXTRACT_ANSWER) function. This function allows you to analyze unstructured data, such as surveys, reviews, or emails, by feeding a simple prompt wi...
Add Decision Making to Your Databricks Toolkit With Mathematical Optimization | Webinar Replay
Просмотров 2768 месяцев назад
Explore the Intersection of Data Science and Decision Making in 'Add Decision Making to your Databricks Toolkit with Mathematical Optimization' - Watch the On-Demand Webinar Now! Presented by Gurobi Optimization and Aimpoint Digital, this webinar is an essential resource for anyone looking to tackle complex decision intelligence challenges through mathematical optimization. Discover the transfo...
QuickEntry: The Native Manual Data Entry App for Snowflake
Просмотров 56811 месяцев назад
QuickEntry is your path to hassle-free, accurate, and efficient Snowflake data management. Its intuitive interface, real-time updates, and seamless Snowflake integration simplify the complexities of manual data entry, making your workflow smoother and more productive. You can download the QuickEntry app for free in the Snowflake Marketplace now! Your Snowflake journey will never be the same. ap...
Data-Driven Growth: Aimpoint Digital + PetScreening
Просмотров 413Год назад
Discover how Aimpoint Digital has empowered PetScreening to harness the power of data for business growth. Learn about our strategic approach to data analytics, the role of Snowflake's data warehouse, and the use of Tableau for data visualization in PetScreening's data infrastructure. See how we've helped PetScreening to build a large advertising business, launch the country's largest free Ambe...
Using Snowpark in Dataiku | An In-Depth Guide & Review
Просмотров 690Год назад
Explore the potential of combining Snowflake's Snowpark with Dataiku in this comprehensive video guide hosted by Alaisha Alexander, an Aimpoint Digital Data Engineer. Learn how to transform and model data using Dataiku's intuitive recipes and Snowflake's cloud-based data platform, all within Snowpark's developer framework. Alaisha thoroughly explains the details of Dataiku recipes, Python recip...
Advanced Data Transformations in SnowPark | Snowflake Tutorial
Просмотров 5 тыс.Год назад
In this RUclips video, Aimpoint Digital’s Snowflake Solutions Architect, Christopher Marland, explains how we can move from ad-hoc data transformations to more professional, scalable, and automated transformations. The video covers topics such as permanent UDFs, MERGEs, reading data from internal stages, and automating Snowpark for Python data transformations using stored procedures and tasks. ...
ServerPAHL: Personal Insights | Alteryx Server Reporting
Просмотров 187Год назад
If you're interested in learning more about Aimpoint Digital’s ServerPAHL reporting suite for Alteryx Gallery, then you've come to the right place! In this video, Bona Wang, a senior analytics consultant, will be discussing the Personal Insights component of “PAHL”. This component enables developers to review and gain insight into their content's performance and usage. Bonna will be giving a de...
ServerPAHL: Audit | Alteryx Server Reporting
Просмотров 134Год назад
If you're interested in learning more about Aimpoint Digital’s ServerPAHL reporting suite for Alteryx Gallery, then you've come to the right place! In this video, Bona Wang, a senior analytics consultant, demonstrates the audit capabilities of “PAHL”, starting with the log and entity tables, followed by the permission audit. The log and entity tables provide information on user and asset activi...
ServerPAHL: Health Check | Alteryx Server Reporting
Просмотров 183Год назад
If you're interested in learning more about Aimpoint Digital’s ServerPAHL reporting suite for Alteryx Gallery, then you've come to the right place! In this video, Bona Wang, a senior analytics consultant demonstrates the health check capabilities of “PAHL”, starting with the server content overview dashboard and summary KPIs that provide insight into the health of content and usage on the serve...
ServerPAHL: Lineage | Alteryx Server Reporting
Просмотров 163Год назад
If you're interested in learning more about Aimpoint Digital’s ServerPAHL reporting suite for Alteryx Gallery, then you've come to the right place! In this video, Bona Wang, a senior analytics consultant demonstrates the lineage component of “PAHL” and showcases a dashboard with controls at the top and KPIs for summary statistics about the selected node. The flowchart below displays nodes encod...
ServerPAHL: The Ultimate Alteryx Server Reporting Tool
Просмотров 282Год назад
Accessing meaningful data on your Alteryx Server can sometimes seem impossible, but Aimpoint Digital has the perfect solution for you - ServerPAHL, the ultimate Alteryx Server reporting tool. With four components - Personal Insights, Audit, Health Check, and Lineage - ServerPAHL optimizes the performance and usage of your Alteryx Server, making it easier than ever to access the insights you nee...
Intermediate Data Transformations in Snowpark for Python | Snowflake Tutorial
Просмотров 6 тыс.Год назад
(Expand for download links) Ready to learn more about data transformations in Snowpark for Python? In this video, we'll explore how to perform various data transformations using Snowpark's Python API, including how to get to and from Pandas, User-Defined Functions (UDFs), semi-structured data in Snowpark for Python, and Window functions. We'll start by discussing how to get to and from Pandas, ...
Dataiku Vlog: How to Correct Data Inconsistencies | DEMO
Просмотров 355Год назад
Dataiku is an AI platform that can yield incredible results for businesses. Aimpoint Digital's vlogging series focuses on Dataiku and Snowflake as integrated solutions, value-add Dataiku use cases across self-service to AI/ML modeling, and innovative ways to extend Dataiku. Take a look at how to correct data inconsistencies with ease utilizing Dataiku. For more information, please visit: aimpoi...
Snowpark for Python | Snowflake Tutorial
Просмотров 31 тыс.Год назад
Snowpark for Python | Snowflake Tutorial
The Aimpoint Digital Difference
Просмотров 113Год назад
The Aimpoint Digital Difference
What Is a Digital Twin? | Aimpoint Digital
Просмотров 1922 года назад
What Is a Digital Twin? | Aimpoint Digital
Our Approach to Data Analytics | Aimpoint Digital
Просмотров 3222 года назад
Our Approach to Data Analytics | Aimpoint Digital
Our Approach to Data Engineering | Aimpoint Digital
Просмотров 2372 года назад
Our Approach to Data Engineering | Aimpoint Digital
Our Approach to Data Science | Aimpoint Digital
Просмотров 1482 года назад
Our Approach to Data Science | Aimpoint Digital
What is Predictive Maintenance?
Просмотров 2512 года назад
What is Predictive Maintenance?
Quantum Computing in Alteryx: The Future of Logistics
Просмотров 5373 года назад
Quantum Computing in Alteryx: The Future of Logistics
Untangling the Data Mesh to Enable Domain-Driven Analytics - LinkedIn Live Webinar
Просмотров 3053 года назад
Untangling the Data Mesh to Enable Domain-Driven Analytics - LinkedIn Live Webinar
What is Alteryx?
Просмотров 147 тыс.4 года назад
What is Alteryx?

Комментарии

  • @christopherhall1216
    @christopherhall1216 10 месяцев назад

    Alteryx is easier than google maps at finding pubs?

  • @AlessandroBertolino-j1z
    @AlessandroBertolino-j1z 10 месяцев назад

    doesn't recognize my config module from config import * ModuleNotFoundError: No module named 'config' what should i do? thanks in advance

  • @gayatrishowseeker
    @gayatrishowseeker 10 месяцев назад

    Hi Where I can find the snowflake account id?

  • @wadewinterhalter6987
    @wadewinterhalter6987 10 месяцев назад

    great video and series. i got stuck on the website udf. turns out on my set-up, the 'html' column was saved as 'binary' instead of 'string', had to add binarytype() to my snowflake.snowpark,types import and use input_types=[BinaryType()] instead of StringType()

  • @dipeshg8581
    @dipeshg8581 Год назад

    So snowpark code is just like databricks pySpark code :D . Thanks It's clear now that Snowpark and Databricks are for spark processing.

    • @jmcloudpro
      @jmcloudpro 4 месяца назад

      Same feeling. I’ve been using apache spark. And I found very similar.

  • @saravanandinakaran2925
    @saravanandinakaran2925 Год назад

    Good. Keep doing more

  • @br2478
    @br2478 Год назад

    Amazing content, thanks for sharing. I have a few doubts 1. What are the pros & cons of Snowpark vs SageMaker 2. If we want to redo SageMaker codes with Snowpark are there limitations? 3. Are there data type challenges of using Snowpark? 4. Quickest way to ramp up on Snowpark?

  • @dataecstasy
    @dataecstasy Год назад

    what would you do if you;re getting your data from snowflake

  • @abinashbehera7518
    @abinashbehera7518 Год назад

    how do we cast date to string or string to date in snowpark?

  • @harshpatil9336
    @harshpatil9336 Год назад

    i have a grouped snowpark df i am trying to calculate a median of target column can u pls help currently i am trying df.groupby(columns).agg(median(targetcol)) its not completing

  • @shubhamgoyal5908
    @shubhamgoyal5908 Год назад

    Hey, great introductory video, can you advice how I can access a nested column while selecting them from a table?

  • @aashish_stanl
    @aashish_stanl Год назад

    Do you have the full course of the alteryx? I am looking for it.

  • @TheHoghead6
    @TheHoghead6 Год назад

    what ide are you using?

  • @phanindrareddymula3731
    @phanindrareddymula3731 Год назад

    13:28 what is F.Col ?

    • @VK7652
      @VK7652 6 месяцев назад

      did you get ? i have same qs

    • @akanerdcaps
      @akanerdcaps 7 дней назад

      Not sure if its still a question, but F is an alias for Snowpark Functions that are imported. Similar to how we write import pandas as pd and then do pd.read_csv(), etc.

  • @trakmakerai
    @trakmakerai Год назад

    whats the IDE?

    • @wuajaz91
      @wuajaz91 Год назад

      Visual Studio Code

  • @kiranpatil444
    @kiranpatil444 Год назад

    This is one of the best snowpark video I have found among RUclips. So easy to understand and point to point.

  • @77sushanto
    @77sushanto Год назад

    I have a SQL problem which I want to solve. Able to achieve half the way but another part is pending, pls help in this. Thank you for so beautiful simple explanation

  • @AtzmonBen-Binyamin
    @AtzmonBen-Binyamin Год назад

    Great series of videos!!! Well explained.. Thanks! BTW, I don't see a .sql file in the zipped folder... Am I missing something?

    • @AimpointDigital
      @AimpointDigital Год назад

      Thank you so much for your support! The zip file has now been adjusted and should have everything you need.

  • @rushikeshdhok8249
    @rushikeshdhok8249 Год назад

    Hi, Thanks for the great content. I recently got a chance to work on Snowpark python. I am pretty much new to this. Can you please make a video on "Working with python worksheet on snowflake UI" and how to deploy it also I want to how to get arguments to that python script to take user inputs. Keep posting such great videos.

  • @PraxeoIogy
    @PraxeoIogy Год назад

    Source control?

  • @cellentmaya1533
    @cellentmaya1533 Год назад

    Thanks for this video. I create my dataframes using the snow_session.sql('select * from table') format. Is it possible to convert this snowpark dataframe to a pandas dataframe. The reason I am asking this is because I would like to save my snowpark dataframe to a csv file.

  • @varuntyagi228
    @varuntyagi228 Год назад

    Great Video!! Can you please create a video on how to design the Session Configs section so that it can connect to Snowflake that has Single Sign On and also how to move this code in QA and production environments ( CI/CD)? you can also create a Udemy course for that I will buy that :)

  • @Juan-Hdez
    @Juan-Hdez Год назад

    Very useful. Thank you!

  • @AZIARGROUS
    @AZIARGROUS Год назад

    Very nice. So basically, snowpark is "async" by design in a way.

  • @SonLeTyP9496
    @SonLeTyP9496 Год назад

    snowpark is good imo, the only things I dont like it much is snowpark only supports only python 3.8.

  • @ronnitroyburman4165
    @ronnitroyburman4165 Год назад

    This is one of the best Snowpark tutorials out there! Thanks @Aimpoint Digital!! Will be tuned in for future videos.

  • @agermoune
    @agermoune Год назад

    Wow! Very simple to understand and love the combination of coding and theory explanation. Chris, you got the gift to convey a complete message in an easy one. Please don't stop as there a not a lot of clear snowpark videos on RUclips. One thing I was hoping to see is the initial setup and connection to snowflake also importing snowflake connection. Liked, subscribed immediately, and even pushed the bell so I won't miss any future videos

  • @JohnLanze-hz4ql
    @JohnLanze-hz4ql Год назад

    Quantity was applied to just the discount which is how this ended up with the negative revenues. Quantity should have been applied to the whole equation. Enjoyed the video though. Good walkthrough

  • @kamsalaharikrishnababu4746
    @kamsalaharikrishnababu4746 Год назад

    nice explanation

  • @AS-yo2uy
    @AS-yo2uy 2 года назад

    Can you u use alteryx for biology?

  • @PeterCacioppi
    @PeterCacioppi 2 года назад

    Python is actually quite easy to learn. Learn Python, and you won't be hamstrung by the limitations of a graphical substitute for actual programming. Moreover, you'll be able to take your Python skills with you from job to job, as opposed to building a career around the narrow set of employers who are using this or that proprietary alternative. If you're the sort of person who likes logical abstractions, then you will do well with Python. If you're not that sort of person, then you shouldn't be doing doing data cleaning and analysis work anyway. Cleaning and analysis is all about clear logical thinking. People that do well with that sort of task don't need a dumbed down alternative to actual programming.

    • @maxfinnian
      @maxfinnian 2 года назад

      And if you do happen to want a drag-and-drop view for your pipeline, just install the free app Orange from your Anaconda dashboard. If the tool already exists for free then why make it a paid service?

    • @PeterCacioppi
      @PeterCacioppi 2 года назад

      @@maxfinnian The future of drag-drop quasi-programming likely going to be free tools that do baby-Python tasks and blend well with Python itself.

    • @amjan
      @amjan Год назад

      What you say resonates with me, thanks for sharing your opinion!

    • @Pyramidtank
      @Pyramidtank Год назад

      Orange in anaconda

    • @Pyramidtank
      @Pyramidtank Год назад

      Orange in anaconda

  • @Techno1497
    @Techno1497 2 года назад

    I really like it !

  • @danjsy
    @danjsy 3 года назад

    Thanks, a good watch and very appropriate foundation for modern analytics.

  • @Mono4627-k3p
    @Mono4627-k3p 3 года назад

    then who needs ML engr. , data scientist and data analytics anymore? if we have this software? Were those position I mentioned created this Alteryx? or is it the software engr. ? Either way, they dug graves for those positions except software engr.

    • @Alejoacuna
      @Alejoacuna 2 года назад

      Good insight, have the same questions as you, been living the transformation to a similar tool in my current position and makes me wonder if they will cut down on headcount because of this

  • @TableauTim
    @TableauTim 3 года назад

    Love the cat !

  •  4 года назад

    This is an absolutely brilliant introduction to Designer! Fun, informative and a great production! Well done! Can you make APA as easy and clear to understand?

  • @bernardthefourth
    @bernardthefourth 4 года назад

    So I buy a bunch of Alteryx stock, give it a few years and I retire RICH?

    • @Annalou1229
      @Annalou1229 4 года назад

      Yes i would like to know too lol

    • @AimpointDigital
      @AimpointDigital 3 года назад

      Aimpoint Digital don't offer financial advice, but only invest what you're prepared to lose and a diversified portfolio is key to reducing risk.

    • @bernardthefourth
      @bernardthefourth 3 года назад

      @@AimpointDigital THATS A YES! I do actually own some at 120 or so.

    • @335637880
      @335637880 3 года назад

      @@bernardthefourth lmao

    • @stuckcamping
      @stuckcamping Год назад

      Don't think that investment has paid off

  • @AaronPaul_google
    @AaronPaul_google 4 года назад

    Hi there. This was a quick helpful video. Meanwhile, is Incremental loading possible in Alteryx and how is this handled?

    • @AimpointDigital
      @AimpointDigital 3 года назад

      This would require filtering out data that is already in your target. To do this, join your source data with the target dataset on a key field. The unmatched records will be the delta for loading. You can leverage the power of your database to make this process quicker by using the In-Database Tools in Alteryx. Please reach out to the Alteryx Community for more help.

  • @kaushikmalepati2495
    @kaushikmalepati2495 4 года назад

    etl, ml, reporting . Wow it can do a lot!