The IBTROS application is divided into two main components: IBTROS_Telegram and IBTROS-Splunk-BigQuery-Fraud-Detection.

Converse naturally with prompt	Get response from db

git clone https://github.com/Jerryblessed/gemini_IBTROS.git

cd ./IBTROS_telegram

python core.py

def __order_menu(self):

The method is called in the core.py file, in the method definition:

Thanks to google cloud big query and splunk, we can do anomaly detection on financial transactions.

This project shows how customers can use Splunk and GCP BigQuery to do anomaly detection on financial transactions by ingesting data, training the model, and detecting the fraudulent transactions. Data used is randomly generated sample data without PII.

This project assumes that you already have a Splunk instance and a GCP BigQuery table. The creation, maintenance, and deletion of these upstream resources are outside the scope of this project.

might take few seconds to load the media

# start_date = '2023-01-01'
# end_date = '2023-03-31'
python datagen.py

Execute the create_model.sql script in BigQuery

# start_date = '2023-04-01'
# end_date = '2023-04-3'
python datagen.py

python splunk-ingest.py
# This ingest to main index
# this will ingest one record every 5 seconds

While splunk-ingest.py is running, Open Splunk.ipynb and run the cells.

 0. Create index named 'anomalies' in Splunk and update the token in the notebook
 1. Create a Search Job and Get SID from Splunk ( adjust time range in the notebook)
 2. Get Results for the SID
 3. Detect Anomaly using our trained model inBigQuery 
 4. Post new detected anomalies to Splunk

Results

Copyright 2024 Google LLC

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

https://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.