[新機能]入力テキスト内の個人を特定できる情報 (PII) をプレースホルダー値に置き換える「AI_REDACT関数」がパブリックプレビューとなったので試してみた

select
    AI_REDACT(input=> '私の名前はかわばたです。電話番号は080-1234-5678。暗証番号は1234。');

-- データベースとスキーマを適切に指定してください
USE DATABASE KAWABATA_MART_DB;
USE SCHEMA AI_REDACT;

-- 音声ファイル専用の内部ステージを作成
CREATE STAGE audio_stage
	DIRECTORY = ( ENABLE = true ) 
	ENCRYPTION = ( TYPE = 'SNOWFLAKE_SSE' );

  SELECT 
  AI_TRANSCRIBE(
    TO_FILE('@audio_stage','call_recording_01.wav')
    );

{
  "audio_duration": 14.75,
  "text": "Hello, I'm Sarah Miller. I'm calling to inquire about the AC7892 air conditioner unit. I saw it on your website and I had a few questions. First, what's the BTU rating? And second, does it come with a remote control or is that sold separately?"
}

WITH transcription AS (
    SELECT AI_TRANSCRIBE(TO_FILE('@audio_stage','call_recording_01.wav')) AS result
)
SELECT 
    AI_REDACT(result:text::string) AS redacted_text,
    result:audio_duration AS audio_duration
FROM transcription;

Hello, I'm [NAME]. I'm calling to inquire about the AC7892 air conditioner unit. I saw it on your website and I had a few questions. First, what's the BTU rating? And second, does it come with a remote control or is that sold separately?